Yea I often use something like TABLE: AGENTS COLUMNS: AGENT_ID, AGENT_NAME, ETC but I was kind of just thrown in to write this simple script querying an Access database created by non-database personnel
.....back to the drawing board ----- Original Message ----- From: "dave" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Wednesday, May 24, 2006 9:17 PM Subject: Re: insert query error - ANY FIX IDEAS? > " Yea that might be it .. i'll switch it up .. but wouldnt the error state > THAT and not 'datatype mismatch' ??" > > It's microsoft so of course it wont...... > > here is a list, "name" is on there, I would check them all > http://support.microsoft.com/default.aspx?scid=kb;en-us;286335 > > FYI~ I name all my tables with a scheme, I don't use this one but a lot of people do, just prefix with something like tbl_ > > so name would be tbl_name > > most ppl use tbl_ but what I found is that if you use that and other ppls code (like phpbb) for example that they also prefix with tbl_ so I just made up my own so I always know which tables are mine. > > ~Dave the disruptor~ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241419 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
