NYCPHP Meetup

[Jeff]

OIC.

-----Original Message-----
From: Sexton, David [mailto:David.SextonJr at ubs.com] 
Sent: Thursday, June 19, 2003 10:17 AM
To: NYPHP Talk
Subject: RE: [nycphp-talk] MySQL and spaces in data


This might be your problem... spaces are illegal...
http://www.w3.org/TR/html4/types.html#type-cdata

-----Original Message-----
From: Jeff [mailto:jsiegel1 at optonline.net]
Sent: Thursday, June 19, 2003 11:12 AM
To: NYPHP Talk
Subject: RE: [nycphp-talk] MySQL and spaces in data


I'm creating check boxes on the fly. Here's a sample of the output on
the form:

<input name="ALFA-ROMEO|1600 DUETTO SPIDER" type="checkbox" value="1">

Now here's the post data:
[ALFA-ROMEO|1600_DUETTO_SPIDER]

Jeff

-----Original Message-----
From: tom at supertom.com [mailto:tom at supertom.com] 
Sent: Thursday, June 19, 2003 9:58 AM
To: NYPHP Talk
Subject: RE: [nycphp-talk] MySQL and spaces in data


Jeff,

What does your insert query look like, and what type of column are you
inserting into?  I can't yet see why this would happen (spaces replaced
with
underscores).

Tom



-----Original Message-----
From: Jeff [mailto:jsiegel1 at optonline.net]
Sent: Thursday, June 19, 2003 10:50 AM
To: NYPHP Talk
Subject: [nycphp-talk] MySQL and spaces in data


How does MySQL handle the following?

I'm trying to save a car model called "1600 DUETTO SPIDER."
I noticed it saves it with underscores.

What happens when I retrieve that data in a query? Does it come back as
1600_DUETTO_SPIDER?
Or, if I need to retain the spaces, do I do something like %20 or
something like &nbsp; when I save the data?

Jeff


















Please do not transmit orders or instructions regarding a UBS account by
email. The information provided in this email or any attachments is not
an
official transaction confirmation or account statement. For your
protection,
do not include account numbers, Social Security numbers, credit card
numbers, passwords or other non-public information in your email.
Because
the information contained in this message may be privileged,
confidential,
proprietary or otherwise protected from disclosure, please notify us
immediately by replying to this message and deleting it from your
computer
if you have received this communication in error.  Thank you.

UBS Financial Services Inc.
UBS International Inc.



--- Unsubscribe at http://nyphp.org/list/ ---