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!

Register Log in
  • Congratulations bkrike 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: *

  • Users: crjo
  • Content: Threads
  • Order by date
  1. crjo

    Alert for incorrect password

    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)...
  2. crjo

    Object Required

    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)...
  3. crjo

    Parse error

    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...
    • crjo
    • Thread
    • Replies: 2
    • Forum: MySQL
  4. crjo

    Parse error

    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...
    • crjo
    • Thread
    • Replies: 0
    • Forum: Adobe
  5. crjo

    temp table and join

    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...
    • crjo
    • Thread
    • Replies: 3
    • Forum: MySQL
  6. crjo

    unwanted CR in csv output

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

    Word 2K Find and Replace w/wildcard

    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?
  8. crjo

    display input text boxes equal to specified quantity

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

    Random number as Default Value

    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?
    • crjo
    • Thread
    • Replies: 1
    • Forum: MySQL
  10. crjo

    &lt;b&gt;Add Date/Time Stamp when recordset updated&lt;/b&gt;

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

Part and Inventory Search

Back
Top