Sql Help..! - ASP Free

ASP Free Forums Sponsor:

January 16th, 2005, 07:04 AM

johndunne00

Registered User

Join Date: Jan 2005

Posts: 17

Time spent in forums: 1 h 54 m 36 sec
Reputation Power: 0

Sql Help..!

hi all this is my 1st post i hope you can help what i am tryin to do is an sql
query rthat searches a data base i am using the folowing code successfully but i wanna change it a tiny bit
strSQL = "SELECT location.* FROM location WHERE (cardid='1')"
i need to change cardid to check against an asp var.. so somethin like strSQL = "SELECT location.* FROM location WHERE (cardid=my_var)"
any ideas help would be appricated
thanks john

January 16th, 2005, 09:35 AM

lewy

Alter Ego Wizard

Join Date: Jun 2004

Location: Edinburg Tx

Posts: 4,384

Folding Points: 1009 Folding Title: Novice Folder

Time spent in forums: 1 Month 1 Week 1 Day 23 h 40 m 30 sec
Reputation Power: 1488

Code:

strSQL = "SELECT * FROM location WHERE cardid='" & my_var & "'"

Where my_var is an asp defined variable.

Please don't crosspost.
http://forums.aspfree.com/t45663/s.html

Last edited by lewy : January 16th, 2005 at 09:40 AM.

Viewing: ASP Free Forums > Database > Microsoft SQL Server > Sql Help..!

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump