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!

  • Congratulations SkipVought 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: SecondToNone
  • Order by date
  1. SecondToNone

    Displaying A Text Field In Red

    try this: color="#FF0000" -SecondToNone
  2. SecondToNone

    on the fly password encryption

    Should that be Password instead of Passwort?? -SecondToNone
  3. SecondToNone

    Managing field state across pages

    attaching these values(i mean checkbox values) in the Prev and Next Navigation links... please show your code so that someone here can suggest you a solution... Thanks -SecondToNone
  4. SecondToNone

    interactive calendar

    Take a look at this: http://www.educesoft.com/resource/calendar/calendarmain.asp -SecondToNone
  5. SecondToNone

    Checking for duplicate records before inserting

    Try something like this: <% Dim name, email, country, sql_insert Dim rs = Server.CreateObject(ADODB.RecordSet) name= request.form("name") email = request.form("email") country = request.form("country") 'Connection String is here strSQL = "Select * from yourtable where name='"&name&"' AND...
  6. SecondToNone

    INSERT INTO table with only fields that exist

    Do you want those extra fields in t1 too?? If not you can just do a UNION ALL query -SecondToNone
  7. SecondToNone

    CALCULATE IN QUERIES

    SUM(yourcolumn) - gives the sum of all the values in the column Count(yourcolumn) - gives the count of all the values in the column then you can easily get the average from these two numbers... or i guess you can use the AVG() function... -SecondToNone
  8. SecondToNone

    Displaying records in a table

    Try Group By Topic in your SQL query... -SecondToNone
  9. SecondToNone

    month by month summary...

    did you try... group by budgetmonthid and then group by budgetyearid -SecondToNone
  10. SecondToNone

    Submitting username to DB

    try using a session variable to persist the value of username...something like this... Session("username")=Request.form("username") now you have this Session("username") variable available throughout the session.. -SecondToNone
  11. SecondToNone

    using column headers to re-sort query results

    Try this: once the user enters both the dates save these values to two session variables... Session("start_date")=Request.Form("start_date") Session("end_date")=Request.Form("end_date") then check on these check variables...when the results are displayed for the first time and user just wants...
  12. SecondToNone

    Date Calcluation in Query

    put it as a case statement... Show us your complete query... -SecondToNone
  13. SecondToNone

    Date Calcluation in Query

    i think you are doing the other way round... when you first stated your logic...you wanted to add days if your Date800 field is NOT null...in the above query you are doing the opposite... -SecondToNone
  14. SecondToNone

    How to change URL of browser when submitting a form.

    i think you need additional components for cross browser support... -SecondToNone
  15. SecondToNone

    How to change URL of browser when submitting a form.

    No problem...we are all here to learn... glad its working for you -SecondToNone
  16. SecondToNone

    How to change URL of browser when submitting a form.

    Try this: Mailer.AddRecipient "Mark", "Mark@23k.com" Mailer.AddRecipient "John", "John@23k.com" Mailer.AddRecipient "Tom", "Tom@23k.com" Mailer.AddRecipient "Karl", "Karl@23k.com" and so on... -SecondToNone
  17. SecondToNone

    How to change URL of browser when submitting a form.

    I meant: if Mailer.SendMail then Response.Redirect "http://www.23k.com/vertex_form/success.html" -SecondToNone
  18. SecondToNone

    How to change URL of browser when submitting a form.

    Try Response.Redirect "www.blah.com" -SecondToNone
  19. SecondToNone

    Attempting to find records on partial match

    Did you try the % instead of * -SecondToNone
  20. SecondToNone

    Date Calcluation in Query

    did you mean something like this: If date800<>"" THEN DateAdd(d,75,date802) < date803 End -SecondToNone

Part and Inventory Search

Back
Top