Recent content by DaveGerard

>>sql=select * from table where value='&quot;& value2 &&quot;'&quot; >> >>and then went if value1 <> value2 then >>&quot;data is invalid&quot; So is the field named value or value1? Didn't you just want to check to see if there were any matches and if not display your message? Maybe I'm...

Hey BullSchmidt I like the bar charts on your site. I thought of that same thing a few years ago, but I was going to have it span the last 30-31 days, like for sales trends and performance. I thought that maybe it wasn't going to be quick loading and started looking into graph generators. How...

Sorry it took so long. I had to tuck the wife in...haha. She's pregnant and can hardly stand the late hours any more. >>I'd like to have the NEW icon only show up if a record is no more than an hour old. Well, here ya go. I had to think about this one for a minute. Let me know what you think...

For starters you'll need to call the images for &quot;severity&quot;. If they are named like you said, all you have to do is the following: <img src=&quot;severity<%=rs(&quot;Severity&quot;)%>.gif&quot; border=&quot;0&quot;> =============== For the space under the dropdown move the form tags...

What are the 4 images for severity 1-4? Can you post a link to them? Dave

Your <option> inside the loop also says &quot;All&quot;... <%if MyApplication = &quot;All&quot; then%> Rather it should say <%if MyApplication = rsApp(&quot;Application&quot;) then%>

One more thing. You can get the dropdown to display the option that you are currently filtering by doing the following to both the &quot;ALL&quot; line and the looped line... CHANGE: <% <option value=&quot;MultiRecords.asp?MyApplication=All&quot;>All Applications</option> <option...

Ahh Slakker!. I see you got it figured out. Just refreshing your screen and saw you had it working prety good. Cool routine do you think? Dave

Let me explain that last one further. If the record has a status of some severity, and I'm assuming that it's either Severe or Not Severe. Then it should be a Yes/No DataType. If there are different severity levels like 1 through 5 then the field should be numeric using 1 through 5 and the...

Oh yeah. DataType for images should probably be Yes/No (formatting set to true/false). CHANGE: <td width=&quot;13%&quot; align=&quot;center&quot; bgcolor=&quot;#ECECFF&quot;><font face=&quot;Arial&quot; size=&quot;2&quot;><%=rs(&quot;Severity&quot;)%></font></td> TO: <td...

Looks great. MultiReacords was just the name of the file that I used. Change your options as follows: FROM: <select size=&quot;1&quot; name=&quot;MyApplication&quot; onChange=&quot;if(this.options[this.selectedIndex].value!='$')...

Really? Explain this then... Active Server Pages error 'ASP 0130' Invalid File attribute /login/LoginProcess.asp, line 1 File attribute '/connect.inc' cannot start with forward slash or back slash.

Yeah, help you solve what problem? You had a sentence that said you could delete files and that it happens. What do you want to do, delete or not delete? If not, try renaming your file as you upload it to something distinct like filename_timestamp.jpg or something.

Almost forgot. I have the column headings (HTML) within the recordset loop as I do the data columns, however it is only displayed once as I am counting records as I loop. I put the row with those headings inside the loop rather than outside the loop because as data gets longer and stretches...

As promised, here it is. You can use images instead of new, status, and severity columns. I'm assuming that those columns are Yes/No columns. I usually set the format for those to True/False as it is more similar to MsSql Server's &quot;bit&quot; data type, which is 1/0 (true/false). I believe...