How can I use a string for the query? (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

Mojo -> 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 -> 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 -> 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).]




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
3.100586E-02