Search results for query: *

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...

The problem is referencing rsData(&quot;Category&quot;) when you could be at EOF. One way you could deal with this is to read rsData(&quot;Category&quot;) into another variable (let's say strCategory) and check the variable in your do until instead of the value in the recordset (i.e. Do Until...

Hi Kristen, I think this line do until strCurrCategory <> rsData(&quot;Category&quot;) will generate an error if rsData is already EOF. You need to change this so that you're not doing this comparison when you get to EOF. Hope this helps, Cathy

You're right, if hits and at bats are integer, then the result will be integer. I'm not sure, but you may be able to use the cast or convert function to convert these to numeric or decimal. As for the rounding/formatting, I think there is a Round function that could help. However, depending...

I think onpnt was onto something a bit earlier concerning the data type of Session(&quot;UserGood&quot;). In login2.asp, in all cases except one, you set it as a string (i.e. Session(&quot;UserGood&quot;) = &quot;True&quot;), but in the 2nd to last line, you set Session(&quot;UserGood&quot;) =...

Hi RJKealey, I may be missing something, but if dbconnect.asp is a different page, the include there will not transfer over to this page. You will need to include it here as well. I also have a question about your connection string MyConn (on your RS.Open statement) - where is that getting...