Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cathyw

    Connect SQL Server, Easy Way

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

    Hi, I get confused, code(1) does no

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

    Stored Proc returns no data

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

    Why ASP/SQL error occurs only occasionally: Command text not set

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

    Why ASP/SQL error occurs only occasionally: Command text not set

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

    Search for column name

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

    ASP to Excel in HTTPS

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

    NEED HELP WITH UPDATE PROCEDURE

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

    NEED HELP WITH UPDATE PROCEDURE

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

    Can I pass objects to a COM component?

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

    Valid Script

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

    ERROR: Arguments are of the wrong type, etc.

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

    SQL SP that returns no records error.

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

    Prevent cache-ing

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

    No EOF or BOF, Exception error, but records are showing

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

    No EOF or BOF, Exception error, but records are showing

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

    No EOF or BOF, Exception error, but records are showing

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

    Calculations in stored procedure

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

    asp errors

    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;) =...
  20. cathyw

    error while paging thru recordset

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

Part and Inventory Search

Back
Top