I am using UPDATE to set the fields in my database and after hours of testing I find that UPDATE won't
allow me to insert ' ticks at the beginning and end of my values.
I can use ' ticks when I insert without problem just not when I UPDATE.
Has anyone ever heard of anything like this?
Can you show me where I went wrong?
I echoed the value just before it is placed in the UPDATE string and it clearly shows the ' ticks. I ran another test by placing the letter "z" in front of the tick to prove that my function was working properly and it worked great.
Very confused and could use some help.
Kevin