|
| |
|
|
Mojo
Posts: 2477
From: Chicago
Status: offline
 |
How can I use a string for the query? - 3/12/2001 23:51:00
I have a string that I would like to use as the query in the DRW. I am using the Spooky diet on the DRW.I am thinking something like: Select * From Results WHERE "mystring" Any ideas? Thanks, Joe
|
|
|
|
Vince from Spain
Posts: 658
From: Madrid Spain
Status: offline
|
RE: How can I use a string for the query? - 3/12/2001 18:33:00
Hi Joe,
I am assuming that your string has previously been assigned some value. Like for instance . . . .
mystring = "name='Bob'"If that is the case then you can build the query like this . . .
fp_sQry="SELECT * FROM results WHERE " & mystring where the "&" will concatenate the two strings together. All the best Vince
------------------
Internet Business Solutions S.L.(Spain)
| |
|
|
|
Mojo
Posts: 2477
From: Chicago
Status: offline
|
RE: How can I use a string for the query? - 3/12/2001 20:38:00
Vince,Thanks for your help! I had tried that, but it did not work so I moved on. After you set me straight I started looking for another reason why it would not work and found it. Grateful, Joe [This message has been edited by jbennett (edited 03-12-2001).] [This message has been edited by jbennett (edited 03-12-2001).]
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 