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

    Is my "End If" positioned correctly?

    Does the error message give you a line number where the error is actually occuring? This error seems to be happening because you are trying to use a field in the recordset when no information was returned to the recordset. If you can tell what line the error is on, then you can check that line...
  2. bernlaw

    Is my "End If" positioned correctly?

    If I understand your problem correctly, you page is displaying fine and shows the output BUILDER INFORMATION and then below that shows the Submit button but not the form fields in-between. If that is in fact the problem, it would indicate that the problem is that you are attempting to get...
  3. bernlaw

    Two errors in 4 lines

    The Type Mismatch error may be caused if you have a Null value in your recordset. Add an empty string to the end of that value so that if the rsItem("ImageName") is Null then it will put an empty string "" into the variable image_display. image_diplay =...
  4. bernlaw

    Testing Scripts Locally

    You can run IIS (Internet Information Services) which is on the Windows Setup.
  5. bernlaw

    Hello all, I recieve this error

    The error message is because you are trying to use information in a recordset that is not available. On that line, you have RS("project_name") and the recordset apparently does not contain a field called project_name. I noticed that you have created your SQL statement in the...
  6. bernlaw

    Type Mismatch problem with call to VBscript function

    It looks like you are making the function a client side function instead of a server side function. Therefore, when you call the function on the server side it can't be found. Replace the <SCRIPT></SCRIPT> tags with <% and %> so that the function is a server side function. <% Function...
  7. bernlaw

    Calculating an age using VBScript

    What if you selected the number of days between the two, divided by 365 and took the integer of that number. int(datediff(&quot;d&quot;, &quot;9/27/1980&quot;, date) / 365) This will give you 22. The only question I'm wondering about is leap year and how that would affect this. Try this and...
  8. bernlaw

    Need help on how to do this

    Try using a table, inside a table. <table> <tr> <td> <table> <% iCount = 0 while not rs.eof iCount = iCount + 1 if iCount > 10 then '10 items printed, start new column...
  9. bernlaw

    SQL server fields access problem

    The error you are getting is because the field you are trying to print isn't found in the resultset. Check the SQL statement to make sure you are getting the field NUSER. Make sure the field name is spelled correctly, etc. Since you did not include the SQL statement, I can't tell exactly...
  10. bernlaw

    Blank page (no results) from my SQL query

    While SQL *Plus Worksheet shows the date as DD-MMM-YY and you can actually use dates in SQL statements within SQL Worksheet in that format, I've found that it doesn't work when you use the dates in that format from within ASP pages. So that is why you may be having the problem. What I mean...
  11. bernlaw

    Blank page (no results) from my SQL query

    Here's something you might try. I ran into this problem on my Oracle database and ASP. When running a SQL statement in Oracle's SQL Worksheet, dates are used as DD-MMM-YY, however when running the same query from an ASP page I have to use YYYYMMDD format for dates. I can't remember if an...
  12. bernlaw

    Show files of a mapped drive in an ASP

    I believe this has to do with permissions. IIS uses annonymous authentication by default so ASP pages won't be able to see any drives on another server. Perhaps you could set the username that IIS uses from the default to a real NT username that has permissions to view mapped drives. Then...
  13. bernlaw

    Cannot update. Database or object is read-only. ??

    I was logged in as an Administrator and was trying to change the permissions on the entire root tree. It was an XP glitch. Rebooting the computer cleared up the problem. For whatever reason, Win XP Pro wouldn't change them. Perhaps it was because I had just installed IIS and didn't reboot...
  14. bernlaw

    UPDATE assistance needed

    One other thing to check. Make sure your access database isn't flagged as read only. I've found this same error when trying to update a record on an access database that was marked as a read only file.
  15. bernlaw

    response.redirect

    I have to agree with JohannIcon on this one. If more programmers would put the spaces in their coding it would be much easier to debug the code. It's makes spotting errors easier to detect. So use: Response.redirect (proceedingasp & &quot;?tempID=&quot; & tempid & &quot;&delID=&quot; & delID...
  16. bernlaw

    Submitting IFRAME with Form

    I noticed you made a type in your code: var theform = document.frmsdnemail; should be: var theform = document.frmsendmail; That's probably what is causing your problems since it doesn't recognize the object frmsdnemail.
  17. bernlaw

    Cannot update. Database or object is read-only. ??

    I would like to know the answer to this question also. I noticed that all directories and files in the web directory c:\inetput\wwwroot are all flagged as read only when I check the properties by right clicking and looking at properties of the folder. The problem is, if I uncheck the read...
  18. bernlaw

    ADODB Recordset Error

    It appears that after you dimension your string varible you are setting it to a recordset when you execute the SQL statement with objConn.execute. You just want to create a string variable to pass to the open command. So Change this: Dim strSQL Set strSQL = objConn.execute(&quot;SELECT...
  19. bernlaw

    How to judge the value which I get from database is null?

    An easier way to tell if the field is empty is to append an empty string to it. This way a null, or empty string from the database will still show that there's no name. if recordSet(&quot;name&quot;) & &quot;&quot; = &quot;&quot; then response.write(&quot;No name shown.&quot;) else...

Part and Inventory Search

Back
Top