On 3/31/02, Mike Kear penned: >Yes, and it doesn't show anything but the error message. And the memberID >is an identity field. The SQL2K equivalent of Access's autonumber field. If >you try to enter anything in there yourself it barfs on you. > >The SQL inside the <CFQUERY tag works fine when sent using Query Analyser. >So the SQL itself is ok. I'd gladly look at the debug info but the page >doesn't show any. Doesn't show anything but the error message.
That is strange. From before: >IS this the problem?? > >I'm thinking the problem is the SERVER doesn't have permissions to insert >into the database - it needs to be set up as database owner and hasn't been. >Which means I have to focus the SysAdmin's eye on it and that's not easy at >Easter time. IS there anything else I should look for? Something I might >have overlooked? I would think that if you can insert anything through query analyzer then you must have owner or datareader/datawriter permissions. Just for the heck of it, maybe you could try making the memberID field a regular integer field and trying an insert with a value for the memberID hard coded in the cfquery. Also, I know this is probably a stupid question, but since it IS an identity field, you aren't including that field in your insert statement, are you? If you want to email me off list with the username, password database name and IP Address of the SQL Server, along with the query with some hard coded values, I can try it from here to see if it works. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
