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

    adding numbers from mysql database

    You need to check the data type of the 2 variable to see if they are the same, using VarType(rs2("hakemnot")) If the value is 8 then it is a string, you need to convert it. Here is the link to check the data type of a variable: http://www.w3schools.com/vbScript/func_vartype.asp
  2. Kendel

    ConnectionTimeout

    Set con = Server.CreateObject("ADODB.Connection") con.ConnectionTimeout = 10 con.cursorlocation=3 Set cmd = CreateObject("ADODB.Command") cmd.CommandTimeout = 10 This didn't work either. Does anyone know why??? thanks.
  3. Kendel

    ConnectionTimeout

    ASP, IIS6 Set con = Server.CreateObject("ADODB.Connection") con.ConnectionTimeout = 10 con.CommandTimeout = 10 con.cursorlocation=3 strConnection = "DSN=blab ...;uid=...;pwd=...." con.Open strConnection These timeout setting don't work. My query run for 15 seconds and it's not time out. How...
  4. Kendel

    No updates, deletes or inserts are allowed in SQLPrepare

    Like this: "Initial Catalog=<myDB>;DSN=myDSN;uid=myUid;pwd=myPwd;integrated security="
  5. Kendel

    No updates, deletes or inserts are allowed in SQLPrepare

    No, it's not the permission issue. I'm switching from EDBC to ODBC driver using the same DB. Didn't have any problem with EDBC. P.S. It's good to see you are still in this forum. It's been a long time.
  6. Kendel

    No updates, deletes or inserts are allowed in SQLPrepare

    I'm trying to insert a record to a db and I got this error. Set con = Server.CreateObject("ADODB.Connection") con.Open "DSN=MyDB;uid=myuid;pwd=mypwd" con.Execute("insert into myTable values (...,...,blab,blab)") Microsoft OLE DB Provider for ODBC Drivers error '80004005' [CA][ODBC...
  7. Kendel

    System date time

    I'm trying to set up some restriction on a web page. I have this piece of code: <% if time() >= CDate("8:00:00 AM") and time() <= CDate("5:00:00 PM") .... blab ..blab ... end if %> I tested it on the server, it works as expected. But for some unknown reasons, this setting doesn't work for...
  8. Kendel

    passing variables to forms

    Try to put the value inside the quotes: if rVal = "ST" then ... elseif rVal = "CBSA" then
  9. Kendel

    reading word document by using asp programming

    Do you have Word Document installed on the server?
  10. Kendel

    reading word document by using asp programming

    Make sure that you have admin privilege on the server. If you do have admin privilege, then probably it is a security with IIS. What version of IIS do you have? You might need to update to IIS 7.0
  11. Kendel

    Detect Window Close

    I found this link shows how to create drop down list using vbscript, I hope it will help. http://computer-programming-tutorials.suite101.com/article.cfm/how_to_create_dynamic_comboboxes_with_vbscript
  12. Kendel

    Detect Window Close

    I thought the script would wait until step3 is done. If you have a msgbox, the next step won't execute until user click OK.
  13. Kendel

    Detect Window Close

    In your popup window: <body onunload="callSub()">
  14. Kendel

    &quot;Real Time&quot; synchronous update

    There you go. Another solution is to post the form back using the form action: On page1.asp <form name="form1" method="post" action="page1.asp"> Then you check to see if the form is posted back, this piece of code will only execute when the form is posted back. <% If...
  15. Kendel

    Detect Window Close

    Well, I would break that hundred lines of code further. Put the rest of the execution in a sub. When you popup a new window, do some stuffs, then you close it. On unload event of this popup window, execute the rest of the execution by calling that sub.
  16. Kendel

    &quot;Real Time&quot; synchronous update

    The page that displays the message is popup window? If it is a popup window, you will need some javascript to refresh parent window. If it is not, like I said, after user click update button, instead of going to the page to display the message, go back to the "textarea" page. This "textarea"...
  17. Kendel

    Permission Denied MsgBox in vbscript

    I replied before I test it. No, it doesn't work. :(
  18. Kendel

    Permission Denied MsgBox in vbscript

    Hey wvdba, I'm surprised! Mozilla says that FF doesn't VBScript or ActiveX at all. It's good to know. Thanks.
  19. Kendel

    Permission Denied MsgBox in vbscript

    You are using FF aren't you? Sorry, FF doesn't support VBScript :(
  20. Kendel

    &quot;Real Time&quot; synchronous update

    Ah, I think I know what you want. Instead of taking the user to the update page, just take them back to the display page. If you want to inform user that the record has been updated, you can display a message on the page or popup a window to say so.

Part and Inventory Search

Back
Top