[Zope] spaces in postgres data field

Rex McKanry rmckanry@yahoo.com
Wed Aug 6 13:12:38 EDT 2003


Hi all,

I'm having an odd problem with zope. I'm using a
postgres database to store address of employees. When
I get the data from the database it drop off after the
first space. and example would be if the address is
1234 candykane Ln. my text box on the screen would
show 1234 only.

The text box is set for 30 characters and I've tested
the SQL statement in zope and I see it pulls in the
full address spaces and all.

The code looks something like this:
SQL:
select * from employee_records where
(employee_id=<dtml-sqlvar employee_id>)

DTML:
<dtml-in "find_employee_rec(employee_id=employee_id)">
<input type="text" name=<dtml-var address1> size="30">
</dtml-in>

I don't have the code right in front of me but that's
pretty close. I've put under lines in the data base to
take out the spaces and all the information shows up,
which means that the full address is being passed.
Thanks,
Rex

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com




More information about the Zope mailing list