Recent content by foxbox

dim i i = 0 do while not rsOrder.eof varOrder(i) = "<th><a href='?itemid=" & _ rsOrders(0) & "'>" & _ rsOrders(1) & "</a></th>" i = i + 1 rsOrders.movenext loop (not tested)

Your email is HTML formatted, but the email client obviously is not compatible with the <input type='checkbox'> tag. My Outlook 2007 is not. It shows [X] or [ ]....

I expect a ProjectID to be numeric and a Projectname varchar. So in this query you are combining 2 SELECT's that do not produce the same field TYPE (= George's remark): SELECT ProjectID as ProjectName FROM tblTaskToolProRght WHERE [UserID] = 'nato' AND [SuperUser] = 1 UNION SELECT...

Mmmmmm, my initial thought is: 20 minutes processing??!!! if your script does database operations: use a stored procedure. Most likely that will speed up things. Besides that: with programs like this there will be a maximum number of simultaneous jobs (performance wise). I would store every user...

to me it looks like you are sending "raw" characters to the HP. The formatting codes for matrix and laser printers are completely different. For the HP you need PCL5 escape codes. Have a look at: http://pcl.to/reference/

1) use ? in the strSQL 2) use the fieldname in the createparameter <% set objCommand = server.CreateObject("adodb.command") Set objCommand.ActiveConnection = objConn objCommand.CommandText = "SELECT DISTINCT [field1] FROM [table1] WHERE field1 = ?" objCommand.CommandType = 1 Set param1 =...

there is only one way to found out........ and i presume you are clever enough to define and open a connection etc

untested/ pseudocode: <textarea> <% cSQL = "SELECT TOP 10 content FROM chat" rs.open cSQL, conn do while not rs.eof response.write rs("content") & vbCrLf rs.movenext loop rs.close %> </textarea>

??? 1 textbox with data from 10 records? 10 textareas from 10 records? 10 columns? 10 rows? ???

superstrange, it works on my box. i modified it a little to show you the string manipulation: <% cTheString = "Example130-Your Analysis Bus-0.00-W-20032,Help130-My Analysis Aug-0.33-C-20052" response.Write cTheString do while cTheString <> "" 'Where is the first comma? nComma =...

sorry, now i see the , in that string. so there is an outer loop for that code, in which you do a left( string, "comma position") you find that (1st) "comma position" by using the InStr function.

<% c = "Example130-Your Analysis Bus-0.00-W-20032,Help130-My Analysis Aug-0.33-C-20052" a = split(c,"-") for i = 0 to ubound(a) response.Write a(i) & "<br>" next %>

go read the answers in this thread: http://www.tek-tips.com/viewthread.cfm?qid=1617706

Is Violation_ID a textfield? If it is numeric value then get rid of the surrounding ' around valVid. in cases like this a response.write the sql statement (followed by response.end). I can see the final sql, and copy /paste the statement into de SQL enterprise manager...

Maybe this is helpfull too: http://classicasp.aspfaq.com/date-time-routines-manipulation/how-do-i-delimit/format-dates-for-database-entry.html