I'm gonna check on that. The weird thing is that it works when I send the variable through as say "12345", a number, and have the column in the database set to number. But when I change the column to text and try to sent the variable through as MBR-12345, it chokes.
Hey, Here's the code:
(It's saying script error and pointing to this line -->
RS.Open "SELECT * FROM Members WHERE memberID='" &
member_ID & "'"
The page before this one is sending the variable MBR-000005, to this page as mid. <a...
I'm new to SQL. I have a page that is requesing an memberID from another page. It takes it inserts it into a table and displays the members info. it used to be a number, but i am switching it to text and it's not working. The database record has been set to text. I would really appreciate any...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.