Search results for query: *

I know very little about C++ but I'm trying to tackle something for work and need some help... I'm using this C++ ISAPI filter code to add a message to the top of a page on a IIS web server running ASP and CFML. This is a web server that will be going away and need a way to notify the users...

I'm looking at creating a site that allows you to drag/drop pictures, text-boxes, and certain stylized elements onto a template. It should contain the ability to edit the text in the boxes, as well as re-size the elements. There is a site that does basically the same thing using flash, but I'd...

Here's what my data looks like: "12312331 ","DOE, JOHN","3423423",0,1900-01-01 00:00:00,"","@@ ","","JOHN DOE PROCESSING PLANT" Here's my format file: 7.0 10 1 SQLCHAR 0 0 "\"" 0 "" 2 SQLCHAR 0 250 "\",\"" 1...

I'm needing help writing a query that will convert a DATETIME value into a SMALLDATETIME value and drop any DATETIME values that would cause a SMALLDATETIME overflow error (use NULL instead). Something like this maybe? UPDATE TABLE SET THISDATE = CASE WHEN THISDATE) >= 1/1/1900 OR...

I have a SP that will not work when I have the queries in it surrounded by... BEGIN TRAN blah - blah - blah IF @ERROR ROLLBACK TRAN COMMIT TRAN The proc seems to run indefinitely and there are tons of locks on the database it's using. If I remove all the TRAN lines (comment them out) the...

Can someone please tell me why this doesn't work? *'s replace actual secured values. UPDATE OPENDATASOURCE('SQLOLEDB','Data Source=*.*.*.*;User ID=*;Password=*').*.dbo.* SET ExceptionRanked = a.XCP_RNK_IR, SelectionFlg = a.SLE_IR, EUDLoadDt = GETDATE() FROM TADMSMT a INNER JOIN...

Here's the cfoutput, notice how the last two are always 0 yet they should be returning non-0 values: #VARIABLES.lstTraining# - #qryTraining.TNG_SYS_NR# - #ListFind(VARIABLES.lstTraining, qryTraining.TNG_SYS_NR)# - #Find(qryTraining.TNG_SYS_NR,VARIABLES.lstTraining)#<br/> Here's the output...

I need to create a stored procedure that can read in a table from an access database on an FTP server. Is this possible? We are not allowed to use DTS package.

How can I trap an EXEC error? @@rowcount and @@error aren't ever available... The SP seems to stop running altogether once the return is not a result set... For example: SET @strOracleSQL = '' SET @strOracleSQL = @strOracleSQL + 'Select role from session_roles' SET @strSQL = '' SET...

I'm building a dynamic SQL statement in a MSSQL SP. After it's built, I want to set a variable to the only record it returns. Something like this: SET @strCountSQL = 'SELECT COUNT(*) FROM (' + @strSQL + ') cnt' SET @intRecordCountQY = EXEC(@strCountSQL) Of course, it doesn't work -...

I have a variable that is getting filled dynamically by a cursor. It's listed as a VARCHAR(50) and is filled with values (integers) from this cursor followed by a comma so that the final list looks something like this: @lstVariables = "89,3,23" Now, taking that variable, I'd like to be able...