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!

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

Recent content by adroit

  1. adroit

    Which code editor do you use?

    I use Visual Interdev for Writing ASPs and VBScript.It auto-complete feature is best to avoid spelling mistakes and write code Notpad some times for well formed HTML Code. and MS FrontPage for HTML most of the times. I have used Dreamweaver as well and its good to use to HTML Specialy if one...
  2. adroit

    Export recordset from query to Excel spreadsheet

    Hi all, I am using the following code to fetch userids from a database and display it in browser in MS Excel worksheet format. The problem is when i run the code for the first time; it does not show me the results. It works better when I run the same page again while the first instant is not...
  3. adroit

    SQL Error

    Make sure that there is a space between the Fieldnames and SQL Clauses. Check it with Response.Write strSQL then copy/paste and run it directly in the SQL Query Analyzer or access (what ever DB are you using) ---Error Source--- & "airbooking.Name, airbooking.OrderNo FROM AirOrder...
  4. adroit

    problem with passing from data

    Why don't you use PartNumber text box as an array. Each time to inster a new line of Form fields to sheet , Use the same name for the text Box. After submiting the page When you will get a comma seperated list of the all partnumbers you have entered. You will need to use Split() function...
  5. adroit

    problem when reading from a text file

    1. Use Trim(rs("MyTxt")) instead of rs("MyTxt") I Think this will help you. I checked your code and it must work fine except the #(1) as i m not sure what field type are you using. To see your code running . make a text file named "a.txt" in a subdirectory named...
  6. adroit

    Blank page (no results) from my SQL query

    Hi , Every thing seems to be OK. But I would suggest you try 1. Server.URLEncode(recordset("LINK")) instead of (recordset("LINK") . 2. While Not recordset.EOF //code recordset.MoveNext Wend 3. Check for the spelling mistake in the record set...
  7. adroit

    ODBC Connection Timeout

    Setthe connectiontimeout property of the connection to 5 seconds. e.g objConnection.ConnectionTimeout=5
  8. adroit

    FSO - delaying the deleting of a file

    What about using a meta tag refresh tag .? Delete the image after the page is refreshed. Note: Check your file size and calculate its download time(say for 28 k connection for getting idea for setting the refresh time.
  9. adroit

    How do I code Access Style Nav bar in ASP?

    Hi , You can do all this using ASP/VB Script. You just to have all these options on a one very well designed HTML form. All the buttons you will be having there submit the page to a common process page where you can select the user action type using the SELECT CASE for the Submit Button. For...
  10. adroit

    ...error '80004005'...Cannot update the cursor.

    Check the permissions on the database file and the folder. Whenever a update or insert query is run against the file based(like MS Access OR Foxfor database) a temporary file is created and then destroyed right after the transaction is done.Check that you have allowed every one the desired...
  11. adroit

    filesystemobject permissions

    You need to Allow Full Control to Everyone on the Database folder and the Folder where you have uploaded the counter text file Under the security tab.
  12. adroit

    Adding records to access db does not work

    Check the security permissions on the database folder. Everyone must be allowed Full Conrol over the folder where you have placed your access database. Reason : Whenever a record is added to the access database a temporary file is generated till the transaction is completed. As the http user...
  13. adroit

    Run sub from onclick event

    Using Layers can do the trick for you. Make Laysers like layer1 ,layer2,...layer3 unders the main category links. On a mouse click or mouse over even of the javascript set their visibility properties to show the sub links and/hide accordingly . Secondaly you can pass a querystring to the...
  14. adroit

    Read a text file

    Nothing Much Wrong with the Code except you have not created the fso object before opening the text file . 'Copy/paste this line OF code written below 'above "Set f=Set f = fso.OpenTextFile(datapath,1)" Set fso=server.CreateObject("Scripting.FileSystemObject")...
  15. adroit

    Insert text from database to iframe

    NO. The iframe take a url as a src not the HTML atself. Develop a Dynamic page say "iframepage.asp" which will extract these the contents for the the iframe and then use that page in the ifram src tag like . src="iframepage.asp" [peace]

Part and Inventory Search

Back
Top