xml parser

jlin
Posts: 27
Joined: Fri Apr 06, 2001 4:03 pm

xml parser

Post by jlin »

Hi Mark,
Thanks. I will use uppercase first letter for field names to avoid conflicting with the reserved keywords.

But if I do need to have int fields in my table (besides the id of type counter provided automatically) - things like Category_ID, Listing_ID...
Does the timport XML parser support importing integer fields? Can I do something like:

xml
trimspace
field Category_ID int DATASET/RECORD@Category_ID ''
field Listing_ID int DATASET/RECORD@Listing_ID ''

Thanks again.
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

xml parser

Post by mark »

Yes, you can use int. Your problem before was that you were in conflict with an already defined item. '' is not valid default value for int however. You should use a number, like 0.
jlin
Posts: 27
Joined: Fri Apr 06, 2001 4:03 pm

xml parser

Post by jlin »

Mark, It works. thanks!