Search results for query: *

Very simple non-critical password prompt where the password is equal to the page name (Stuff.htm): <script language="javascript"> <!-- begin function Enter() { var location; var password; password=this.document.entryform.inputbox.value location=password + ".htm" fetch(location)...

tsuji, thanks for your help (you too bslintx!) This worked: <% IF (Not isNull(rsRoomRoster("RoomHoldDate"))) AND isNull(rsRoomRoster("AdmissionDate")) THEN Response.Write "<td>" & rsRoomRoster("ResName") & " Room on Hold</td>" ELSE Response.Write "<td>" & rsRoomRoster("ResName") & "</td>" END IF %>

Get 'Object Required' error on the first line of my IF statement: <% IF (rsRoomRoster.Fields.Item("RoomHoldDate").Value IS NOT NULL) AND (rsRoomRoster.Fields.Item("AdmissionDate").Value IS NULL) THEN Response.Write("<td>") Response.Write(rsRoomRoster.Fields.Item("ResName").Value)...

That was the problem. Thanks for your help.

The following statement works fine in MySQL query editor, and DWMX recordset builder but gives the following error when trying to display in browser(PHP): Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING... Here's my SQL: SELECT residents.Resident_ID...

The following statement works fine in MySQL query editor, and DWMX recordset builder but gives the following error when trying to display in browser: Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING... Here's my SQL: SELECT residents.Resident_ID...

Both of these work to a certain degree, but neither is returning the desired result. CREATE TEMPORARY TABLE `tmplist` SELECT medicalrecords.resident_id, medicalrecords.medicalrecorddate FROM medicalrecords GROUP BY medicalrecords.resident_ID; SELECT residents.resident_id, residents.lastname...

I thought of that too. It doesn't matter what field or even what table I use the result is the same.

I have a problem with a carriage return at the beginning of each row of data being exported as a .csv file. My code: <% Response.Buffer=&quot;true&quot; %> <!--#include file=&quot;../Connections/ConnWilbanks.asp&quot; --> <% Dim rsDistList Dim rsDistList_numRows Set rsDistList =...

Went with the macro. Thanks Skip!

I have about 10 pages of text that looks something like this: 9/12/2003,1098,9/15/2003,3421,10/1/2003,7856 etc. I would like to replace the comma between the last digit of the number and the first digit of the date with a carriage return. Can I do this with a wildcard string?

I'll try to make this as clear as I can. User enters number of guests, selects event, then preferably through an onBlur event, an equal number of input text boxes appear. On submit the guest name(s) will be inserted into a MySQL db. <form name=&quot;guestlist&quot...

Converting Access 2K db to MySQL, have field with default value set to display 4-digit random number: =Int(Rnd()*9999) How can I convert this to MySQL?

As usual, the obvious solution is the simplest: Private Sub SomeField_AfterUpdate() Me.EditDate.Value = Now() End Sub

I have a field (EditDate) and I would like it to record the Date & Time when recordset data has been edited/changed.