Recent content by bernlaw

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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