LOL! The purpose of the site is for people to organise nights out etc., so SDFSDF-SFDSDFSD-SFSDFDSF-SFSDFAQE3 can meet up with 345345-sfdds-243234-sdfsdf-r456 and 3432sfd-sfsf-sdf-sfsdfsd
Might get a bit confusing remembering who's who after a few pints... Anyway, back on topic, the debug query appears 100% - is there anything stupid I'm missing if I update on a replication ID? Roll on Friday... G -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 12:33 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Strange update problem user_username = 'CF6FF-SDFSDF-SFSFSDF-SFSDFSDF' Not an easy life... "I name this child, CF6FF-SDFSDF-SFSFSDF-SFSDFSDF" "Do you CF6FF-SDFSDF-SFSFSDF-SFSDFSDF, take this woman to be your lawfully wedded wife?" Ade On a post launch high :O) -----Original Message----- From: Garry Mills [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 12:26 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Strange update problem I've done that: added a debug to the query: returns what appears to be correct SQL syntax, ie update users where user_username = 'CF6FF-SDFSDF-SFSFSDF-SFSDFSDF' - query returns zero rows :( Garry -----Original Message----- From: Aidan Whitehall [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 12:25 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Strange update problem > OK, so a user logs on and I store his user name as a session variable. > If he wants to change his preferences, the script goes... [snip] Turn on ColdFusion debugging and throw a cfabort at the bottom of the page to see exactly what SQL is being sent to the database. And if you're still having problems, open a Query window in Access, paste it in and play around until it works. I've found that's sometimes useful when debugging query problems. -- Aidan Whitehall <[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
