Re: Error when writing a sql statement into a field.

2001-02-22 Thread Ken Yiem
Hi , notice your last field in the Values section. 'query += "\"" + this.customerId + "\",";' get rid of the comma at the end. end replace it with a close'n bracket. notice the last field, you have one extra field in the values bracket. 'xxx","ccc

Re: [OT] Rel DB Question

2001-02-21 Thread Ken Yiem
Hey, it depends on what type of relation you want. I'm no expert, but here's my 2cents. If PEOPLE can only have one shirt, one pants, one shoes ... then (1)your PEOPLE table might look like. CREATE TABLE PEOPLE( people_id auto.. blaa pants_idint ..