I try build a query like: arguments: NAME DESCRIPTION Insert into tablename (description, name) values( <dtml-sqlvar NAME type=string>, <dtml-sqlvar DESCRIPTION type=text>) don't work because type=text how i can fix it? have a nice day jorge
I try build a query like:
arguments: NAME DESCRIPTION
Insert into tablename (description, name)
Do you mean (name, description)?
values( <dtml-sqlvar NAME type=string>, <dtml-sqlvar DESCRIPTION type=text>)
don't work because type=text
how i can fix it?
Looks like you have the two the wrong way around, hence description is being set to NAME and name is being set to DESCRIPTION and thus the types are wrong. John -- John Chandler / Software Developer / New Information Paradigms Ltd [ Linux in the office, AmigaOS in the home, PalmOS in the pocket ] ------------------------------------------------------------------------ The opinions above aren't those of my company... ...but then, they aren't really mine either.
Jorge Magalhaes wrote:
I try build a query like:
arguments: NAME DESCRIPTION
Insert into tablename (description, name) values( <dtml-sqlvar NAME type=string>, <dtml-sqlvar DESCRIPTION type=text>)
don't work because type=text
how i can fix it?
use type=string, they look the same in a query ;) afaik there are only 3 types 'int','float','string' and'nb' (for a stringh that must be entered as NULL if empty) ------------ Hannu
I try build a query like:
arguments: NAME DESCRIPTION
Insert into tablename (description, name) values( <dtml-sqlvar NAME type=string>, <dtml-sqlvar DESCRIPTION type=text>)
don't work because type=text
how i can fix it?
type=string :-) You probably want to change to order you are assigning the values. As it is in your query above you are assigning NAME to description and DESCRIPTION to name. Cheers, Stephen -- Stephen Harrison - stephen@nipltd.com New Information Paradigms - www.nipltd.com
participants (4)
-
Hannu Krosing -
John Chandler -
Jorge Magalhaes -
Stephen Harrison