View Single Post
 
Old March 10th, 2005, 03:22 PM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

BrianWren,

   You are right about the stSQL variable. I had pasted that from a script that was calling an integer. I use the following in Access for strings:

'=====
stSQL = "SELECT * FROM tblYourTable WHERE Name = " & "'" & stName & "'"
'=====

   Indeed, this is how the wizards write it when passing a string. I have never used """. I'll give that a try.




mmcdonal