Click here to Skip to main content
15,919,749 members
Home / Discussions / Web Development
   

Web Development

 
GeneralExtracting info from forms Pin
georgiek5019-Dec-02 23:36
georgiek5019-Dec-02 23:36 
GeneralRe: Extracting info from forms Pin
Victor Boctor21-Dec-02 3:13
Victor Boctor21-Dec-02 3:13 
Generalvedio Conference Pin
salah_gis19-Dec-02 0:04
salah_gis19-Dec-02 0:04 
QuestionWhere am I?? Pin
Sarvesvara (BVKS) Dasa18-Dec-02 22:45
Sarvesvara (BVKS) Dasa18-Dec-02 22:45 
AnswerRe: Where am I?? Pin
Nnamdi Onyeyiri20-Dec-02 2:46
Nnamdi Onyeyiri20-Dec-02 2:46 
GeneralRe: Where am I?? Pin
Sarvesvara (BVKS) Dasa20-Dec-02 19:36
Sarvesvara (BVKS) Dasa20-Dec-02 19:36 
GeneralImplement a Java media player. Pin
George218-Dec-02 20:00
George218-Dec-02 20:00 
GeneralA Wml question Pin
DamienL18-Dec-02 4:44
DamienL18-Dec-02 4:44 
Hi all,
Please help

In my first card I ask for 3 user inputs. Where you want to start and end your journey and a time you want to travel after, in the format 12:25






<wml>

<card id="card1" title="Journey Planner">
<do type="accept" label="Next">
<go href="#card2">


Enter Start Station

Enter Destination Station

Enter Time






_The problem________________________________________________
In my second card I want to connect to a database in MicroSoft Access and use these variables in an Sql statement. I don't know the correct syntax for connecting to the database or for using the variables in my Sql statement. The Sql statement is incomplete, I just want to know how to use variables within it, setting them equal to something and saying something > $variable
________________________________


<card id="card2" title="Display results">



<%
Dim SqlJunk
'Create a connection odject
Set dbGlobalWeb = Server.CreateObject("ADODB.Connection")

'Database connection info and driver
rsGlobalWeb = "DRIVER={Microsoft Access Driver (*.mdb)};uid=; DBQ=" & Server.MapPath("\.....\database.mdb")

'Set an active connection to the Connection object
dbGlobalWeb.Open rsGlobalWeb

SqlJunk = "SELECT Start.StationName AS Start, Start.Time AS JourneyTime, Destination.StationName AS End FROM Station AS Start, Station AS End, Time AS JourneyTime WHERE Start.StationName LIKE '%" & $Start & "%' AND Destination.Station LIKE '%" & $End & "%' AND Start.Time > #" & $Statement & "#"

Set rsGlobalWeb = Server.CreateObject("ADODB.Recordset")
rsGlobalWeb.Open SqlJunk, dbGlobalWeb, 3

'Now I must display the results
<%=rsGlobalWeb("Start")%>
<%=rsGlobalWeb("JourneyTime")%>
<%=rsGlobalWeb("End")%>

%>





Damien
Generalimail Pin
Sarvesvara (BVKS) Dasa17-Dec-02 20:37
Sarvesvara (BVKS) Dasa17-Dec-02 20:37 
GeneralSome info... Pin
georgiek5016-Dec-02 23:21
georgiek5016-Dec-02 23:21 
GeneralRe: Some info... Pin
Christian Graus16-Dec-02 23:28
protectorChristian Graus16-Dec-02 23:28 
GeneralRe: Some info... Pin
Victor Boctor18-Dec-02 16:33
Victor Boctor18-Dec-02 16:33 
GeneralDIV tags Pin
Nnamdi Onyeyiri16-Dec-02 11:19
Nnamdi Onyeyiri16-Dec-02 11:19 
GeneralRe: DIV tags Pin
Paul Watson16-Dec-02 11:55
sitebuilderPaul Watson16-Dec-02 11:55 
GeneralTic-Tac-Toe Pin
ballyduff16-Dec-02 9:07
ballyduff16-Dec-02 9:07 
GeneralCountry-State-City list Pin
Sarvesvara (BVKS) Dasa15-Dec-02 21:21
Sarvesvara (BVKS) Dasa15-Dec-02 21:21 
GeneralRe: Country-State-City list Pin
Christian Graus15-Dec-02 21:40
protectorChristian Graus15-Dec-02 21:40 
GeneralRe: Country-State-City list Pin
Sarvesvara (BVKS) Dasa15-Dec-02 21:52
Sarvesvara (BVKS) Dasa15-Dec-02 21:52 
GeneralRe: Country-State-City list Pin
Christian Graus15-Dec-02 21:54
protectorChristian Graus15-Dec-02 21:54 
GeneralRe: Country-State-City list Pin
Sarvesvara (BVKS) Dasa15-Dec-02 22:35
Sarvesvara (BVKS) Dasa15-Dec-02 22:35 
GeneralRe: Country-State-City list Pin
Christian Graus15-Dec-02 23:00
protectorChristian Graus15-Dec-02 23:00 
GeneralRe: Country-State-City list Pin
Sarvesvara (BVKS) Dasa16-Dec-02 2:21
Sarvesvara (BVKS) Dasa16-Dec-02 2:21 
GeneralRe: Country-State-City list Pin
Christian Graus16-Dec-02 9:53
protectorChristian Graus16-Dec-02 9:53 
GeneralCheck if connected to internet Pin
imghani15-Dec-02 20:26
imghani15-Dec-02 20:26 
GeneralRe: Check if connected to internet Pin
Sarvesvara (BVKS) Dasa21-Dec-02 19:26
Sarvesvara (BVKS) Dasa21-Dec-02 19:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.