Recent content by cathyw

Hi Rougy, I don't think SERVER and DATABASE are valid in a SQLOLEDB connection string. Check this out: http://www.able-consulting.com/ADO_Conn.htm Hope this helps, Cathy

Switch these 2 lines around iCount=iCount +1 vcol = rst.fields(iCount).name so they should be vcol = rst.fields(iCount).name iCount=iCount +1 You are incrementing iCount before processing the fields, so your code is checking for fields 1 and 2 instead of 0 and 1 (and field 2 will give this...

Hi Tony, Try inserting this line in your stored procedure right before your select statement. SET NOCOUNT ON That will suppress the returning of the number of rows, which might be interfering with the returning of the result set. Hope this helps, Cathy

Hi Skurpyun, It sounds like you have a bit of a mystery on your hands. I notice you're using OLE DB for ODBC for your connection. Is your database in SQL Server? (I'm assuming that it is based on your posting in that forum?). If it is, using the OLE DB for SQL Server provider might work...

Hi Skurpyun, I suspect it may have something to do with the contents of the variables that are being inserted. Do the variables always contain a value? Are you checking for special characters, like apostrophes or quotation marks, in your form variables (those can wreak havoc on the string...

There is probably a more elegant way to do this, but here's one way you can search your stored procedures: 1. generate a script containing all of your stored procedures 2. open the script in any text editor 3. use the find capabilities of the text editor to search for the table name or whatever...

Are you using IE 6 as your browser? If you are, it might be a browser setting. In IE, go to the Tools/Internet Options menu, click the Advanced tab and go to the Security section. Make sure that the "Do not save encrypted pages to disk" option is checked. I know that this solves a...

Hi Lambro, Because you are using a trigger when transactions occur in your transaction table, I would be inclined to force your application to make ALL updates through the transaction table, and let the trigger always update the summary table. In this scenario, you would make your adjustment...

Hi Lambro, I don't see a value for @ScanTranSummary_ID being passed in your exec statement (it is the first parameter listed in the stored proc though). Hope that helps, Cathy

Hi mwinwright, In your first post, you have called the function as follows: a = clsText.GetText (clsComponent, clsProduct, Language) In your last post, you have called it like this: call objText.GetText (objComponent, objProduct, Language, objProduct.count) The arguments you are...

Mun, I think you need to change rs = Conn.Execute(Sql) to Set rs = Conn.Execute(Sql) You need the set in front because a recordset is an object. Hope this helps, Cathy

Hi booboo0912, I know this may be an afterthought now, but I think the problem is that you haven't declared a size for your varchar parameter. The 4th argument (which is blank at the moment) should be whatever the size of the varchar is in the stored procedure. i.e. cmd.Parameters.Append...

Here are a few things you can try: 1. You have conntemp.close twice in your code - once before you close the rs and once after. I think you need to remove the one before (it seems to me if you close the connection, you no longer have access to the rs, so this may be generating the error). 2...

There is a really good FAQ on the subject of caching - faq333-1034.

Hi Kristen, In the sample I gave you earlier, you need to move next BEFORE you check for EOF. If you check for EOF and then move next, you could be on EOF again :) The entire 2nd loop would look like this: <% do until strCurrCategory <> strCategory %> <div style=&quot;font-size: 8pt...