Yah, we've got SQL up and running. Problem is, it's smarter than I am at this point. :^) I just don't get to work with it consistently enough and haven't learned it well enough to take full advantage of the possibilities.
Can anyone recommend good books on Transact-SQL? I've got a very basic level of understanding, but really need to learn more. Thanks everyone! > -----Original Message----- > From: T.J. Roberts [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 20, 2002 8:22 PM > To: Multiple recipients of list witango-talk > Subject: Re: Re: Witango-Talk: Tango & MSSQL questions > > > HEY J. > > ONE SMART WAY TO CREATING DYNAMIC WEB SITES IS TO WIELD A > VERY SMART DATABASE BACK END; TRIGGERS AND STORED PROCEDURES > ARE VERY POWERFUL. MICROSOFT HAS ODBC BUILT IN; ALL YOU HAVE > TO DO IS SET UP A DATASOURCE TO POINT TO THE SQL BACK END > DATABASE AND YOU'RE HOME. YOU CAN DO EVERYTHING ELSE IN > TANGO AND JAVASCRIPT. TANGO WILL RECOGNIZE THAT NEW ODBC > DATASOURCE AND YOUR NEW TUNNEL IS READY FOR SOME ACTION. > > TRY SQL SERVER 2000; IT IS A WELL-HONED SQL SERVER 7. DO YOU > HAVE SQL SERVER UP AND RUNNING? > > T.J. Roberts > http://www.organize-it.com > > > > > > ----- Original Message ----- > From: "Wilcox, Jamileh" <[EMAIL PROTECTED]> > To: "Multiple recipients of list witango-talk" > <[EMAIL PROTECTED]> > Sent: Wednesday, November 20, 2002 5:15 PM > Subject: RE: Re: Witango-Talk: Tango & MSSQL questions > > > Gauthier - thanks for the response. > > > -----Original Message----- > > From: [Gauthier] [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, November 20, 2002 10:53 AM > > To: Multiple recipients of list witango-talk > > Subject: Re: Witango-Talk: Tango & MSSQL questions > > > > > > Just for the second question: > > > > Use the error HTML output on the specifc action (you need > to display > > attributes bar in the view menu) this special result will > only output > > if an error occur during the execution > > > > you can use this error HTML output to display, assign variables for > > debugging, <@sql> report error etc like any other result > (if possible > > with a complete error free code ;) > > Question: how do I get the error info coming back from SQL > to show in the Error HTML output for the action? That's the > part I can't figure out. > > For example, if I try to insert a record with no value in a > field that disallows nulls (and I've not touched the Error > HTML output page) I get this in the browser: > > Error > An error occurred while processing your request: > File: play.taf > Position: Insert > Class: DBMS > Main Error Number: 515 > > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert > the value NULL into column 'UpdateDt', table > 'HIPAAinventory.dbo.tbl_UserInfo'; column does not allow > nulls. INSERT fails. 23000 > > File: play.taf > Position: Insert > Class: DBMS > Main Error Number: 3621 > > [Microsoft][ODBC SQL Server Driver][SQL Server]The statement > has been terminated. 01000 > > File: play.taf > Position: Insert > Class: Internal > Main Error Number: -101 > > General error during data source operation. > > I'd like to capture the error code 515 - I can't figure out > how to get hold of it. If I put anything into the Error HTML > page, I seem to lose this info entirely. > > (OK, I wouldn't actually capture THIS error because my data > validation would catch it up front, but it was an easy error > message to get for this email. ;) > > > > > * normally each action are processed after each other so > the problem > > you mention shouldn't occur You may consider stored procedure to > > return the id of the inserted record (the stored procedure make the > > insert and return the id: SELECT > > IDENT_CURRENT('TABLENAME')+1) > > I hadn't thought about stored procedures; I don't do much db > work these days & never got really proficient at SQL. Is > IDENT_CURRENT the last record in the table in MSSQL? > > > Thanks! > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
