RE: SQL! i'm losing it

2000-05-03 Thread James Glaser
I've run into this sort of thing a few times. 9 times out of 10 it is because of the database not your insert statement. Make sure you have all the field types in the database correctly (IE a string vs an integer), and that you are sending to the database as such. What I generally end up doing

Table Joining Question

2000-04-25 Thread James Glaser
This is really more of a SQL question rather than a Cold Fusion question... but...I am working on a project where I have 2 tables set up to hold information. The reason why I use 2 tables is because for every record in table A there could be 1 or many records in table B. So, my problem i