Re: Computer advise please

Posted by mrunion on August 04, 2005 at 07:14:21 from (216.145.89.2):

In Reply to: Computer advise please posted by Brokenwrench on August 04, 2005 at 05:40:42:

To attempt to answer the "why it does this" question:

Some databases (most databases?) use the apostrophe/single tick (') as a string separator. That means that the TEXT of your reply goes into these string separators when it is put into the database. For example:

'Hello, guys.'

If one types apostrophes and they aren't "escaped" by doubling them, the string becomes corrupted and the database insert will fail. Example:

'That's mine.'

In the above example, the database server looks at the string, says the "THAT" part is the string and "S MINE." has just been tacked on the end and is invalid.

Most schemes handle this by pre-processing your strings and doubling the apostrophes: Example:

'That''s mine.'

Two apostrophes together indicate to the database that a SINGLE apostrophe should be inserted LITTERALLY into the string.

Still, other ways around the problem are to replace all single apostrophes with a double-quote -- as you have seen.

I am NOT saying this is what is actually happening, just tletting you guys know what *may* be happening.

Thanx,
Matt

Follow Ups:

Post a Followup Name: E-Mail: Subject: Comments: Optional Link URL: Link Title: Optional Image URL: Email Notification: If you check this box, email will be sent to you whenever someone replies to this message. Your email address must be entered above to receive notification. This notification will be cancelled automatically after 2 weeks.

TRACTOR PARTS	TRACTOR MANUALS

We sell tractor parts!  We have the parts you need to repair your tractor - the right parts. Our low prices and years of research make us your best choice when you need parts. Shop Online Today. [ About Us ]