Click here to Skip to main content
16,007,163 members
Home / Discussions / Mobile
   

Mobile

 
GeneralLabel background color Pin
Anonymous6-Jan-03 20:58
Anonymous6-Jan-03 20:58 
GeneralProgramming an iPAQ Pin
-- NA --21-Dec-02 7:11
-- NA --21-Dec-02 7:11 
GeneralRe: Programming an iPAQ Pin
Brian Olej6-Jan-03 15:27
Brian Olej6-Jan-03 15:27 
GeneralRe: Programming an iPAQ Pin
-- NA --8-Jan-03 18:54
-- NA --8-Jan-03 18:54 
GeneralRe: Programming an iPAQ Pin
#realJSOP7-Jan-03 3:32
professional#realJSOP7-Jan-03 3:32 
Generalpackaging a vc++ software Pin
xxhimanshu21-Dec-02 1:33
xxhimanshu21-Dec-02 1:33 
GeneralRe: packaging a vc++ software Pin
Daniel Strigl22-Dec-02 21:41
Daniel Strigl22-Dec-02 21:41 
GeneralA Wml question Pin
DamienL18-Dec-02 4:43
DamienL18-Dec-02 4:43 
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
QuestionHow to create a device-specific code in aspx Pin
suresh_sathya12-Dec-02 18:58
suresh_sathya12-Dec-02 18:58 
AnswerRe: How to create a device-specific code in aspx Pin
Jeremy Oldham13-Dec-02 2:19
Jeremy Oldham13-Dec-02 2:19 
Questionhow to modify the menu of "peghelp.exe" in ppc? Pin
mydearsky10-Dec-02 16:18
mydearsky10-Dec-02 16:18 
GeneralWhy Can I Find C++ or C# Code Samples/Libraries For Sending/Receiving SMS Messages To GSM-enabled Phones Pin
Gaul8-Dec-02 3:44
Gaul8-Dec-02 3:44 
GeneralRe: Why Can I Find C++ or C# Code Samples/Libraries For Sending/Receiving SMS Messages To GSM-enabled Phones Pin
Daniel Strigl10-Dec-02 1:07
Daniel Strigl10-Dec-02 1:07 
GeneralHand writing detection. Pin
ColinDavies7-Dec-02 21:11
ColinDavies7-Dec-02 21:11 
GeneralRe: Hand writing detection. Pin
Christian Graus15-Dec-02 22:27
protectorChristian Graus15-Dec-02 22:27 
GeneralFirst post with substance Pin
Christian Graus5-Dec-02 15:41
protectorChristian Graus5-Dec-02 15:41 
GeneralRe: First post with substance Pin
Roger Wright5-Dec-02 16:28
professionalRoger Wright5-Dec-02 16:28 
GeneralFirst (non-admin) post! Pin
#realJSOP5-Dec-02 15:22
professional#realJSOP5-Dec-02 15:22 
GeneralWelcome to the Embedded / Mobile Forum Pin
Chris Maunder5-Dec-02 14:52
cofounderChris Maunder5-Dec-02 14:52 
GeneralRe: Welcome to the Embedded / Mobile Forum Pin
David Stone5-Dec-02 18:46
sitebuilderDavid Stone5-Dec-02 18:46 
GeneralRe: Welcome to the Embedded / Mobile Forum Pin
Megan Forbes12-Dec-02 19:36
Megan Forbes12-Dec-02 19:36 
GeneralRe: Welcome to the Embedded / Mobile Forum Pin
Anders Molin15-Dec-02 14:24
professionalAnders Molin15-Dec-02 14:24 
GeneralRe: Welcome to the Embedded / Mobile Forum Pin
Megan Forbes15-Dec-02 22:10
Megan Forbes15-Dec-02 22:10 
GeneralRe: Welcome to the Embedded / Mobile Forum Pin
benjymous20-Dec-02 0:08
benjymous20-Dec-02 0:08 
GeneralRe: Welcome to the Embedded / Mobile Forum Pin
Megan Forbes20-Dec-02 21:17
Megan Forbes20-Dec-02 21:17 

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.