Re: FN-FORUM Database and asp

date posted 10th October 2000 08:40

Hi Paul,

With text fields, remember to surround them with single quotes, eg:

update thistable set numfield1 = 78, textfield1 = 'New Text Value' where
someID = IDvalue

Thanks,
Justin

Paul Fisher wrote:
>
> Thanks for all the help on the database question. I've decided I need some
> asp experience, so I'm trying out several ways to achieve the same goal
> (doing it is the best way to learn, right?)
>
> Is there anyone about that will take a quick look at two very short asp
> pages for me? They're both working well, but one of fields they update in
> the database should contain text, but the asp page will only work with
> numbers. This is probably a silly little thing but I just can't figure it
> out.
>
> If anyone can help I'll email the pages off list (don't want any flames for
> attachments).
>
> Cheers, Paul
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
> Freelancers and Freelance Jobs
> http://www.freelancers.net
>
> To post to the Forum:
> [EMAIL REMOVED]
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
> To subscribe to the digest for this list or for further information please visit:
> http://www.freelancers.net/forum.html