07-19-2007
|
| Administrator
Join Date: Dec 2006
Posts: 6,056
BRL$: 47,893.43 Thanks: 4
Thanked 16 Times in 13 Posts
Rep Power: 648 | |  How to use a variable to assign SQL field
There is prolly a simple answer to this, but it is driving me crazy...After I've done a successful query of the SQL db, I want to put the results into variables so that they are easier to use. This is the way I normally do this (which is working):*varBookTitle = objRSBooks("Title")*Instead, I want to use a variable to specify the fieldname, which is being passed from user input; it would be something like this, but the syntax is wrong:*varBookTitle = objRSBooks(" & varMYFIELDCHOICE & ")*Does anyone know the exact syntax? I have tied so many things....Thanks,WebGrrl:2sm
To view links or images in this forum your post count must be 1 or greater. You currently have 0 posts.
| |
__________________
Jason p. - Administrator
█ High Quality
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
█ Powerful
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
█
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
| | | |
