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 strongm 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: *

  1. davidste

    add days to date

    Thank you. I have changed that but now I have another problem. Have changed the function to reflect the changes you advised and added a few alert boxes to display values of vars. function addDays(myDate,days) { var closeDate = new Date(); var adDate = new Date()...
  2. davidste

    add days to date

    I have one text box I want the user to fill out with a date, I then have a second text box i want to be poulated with the date entered in the first text box plus 14 days. So far I have the following function addDays(myDate,days) { var myDate = new date(); myDate.setDate(myDate.getDate()...
  3. davidste

    pass param from vbscript to sql

    I am getting this error in the browser from the asp page so VB. Microsoft OLE DB Provider for SQL Server (0x80040E14) Line 1: Incorrect syntax near 'logon'.
  4. davidste

    pass param from vbscript to sql

    I am trying to run the following t-sql stored proc from my VBScript page Create Procedure getUserInfo ( @login nvarchar(8) ) AS USE proj_dashboard SELECT f_forename, f_surname, f_profile_id FROM t_users WHERE f_login = @login basically I wasnt to pull in the login of the...
  5. davidste

    pass params to stored proc in vbscript

    I am trying to run the following t-sql stored proc from my VBScript page Create Procedure getUserInfo ( @login nvarchar(8) ) AS USE proj_dashboard SELECT f_forename, f_surname, f_profile_id FROM t_users WHERE f_login = @login basically I wasnt to pull in the login of the user pass it to...
  6. davidste

    select/join problem

    Thank you very much for your help just tried SELECT t_proj.f_proj_id, t_proj.f_name, t_user_one.f_forename, t_user_one.f_surname, t_user_two.f_forename, t_user_two.f_surname FROM t_proj INNER JOIN t_users AS t_user_one ON t_proj.f_proj_mgr_id = t_user_one.f_user_id INNER JOIN t_users AS...
  7. davidste

    select/join problem

    The problem is my SELECT statement would need to do two INNER JOINS but to the same table and to the same fields in that table. What I want to do is SELECT t_proj.f_proj_id, t_proj.f_name, t_users.f_forename (for manager), t_users.f_surname (for manager), t_users.f_forename (for sponsor)...
  8. davidste

    select/join problem

    In one SELECT statement I want to return f_proj_id, f_name, f_manager_id (converted to forename and surname from t_users), f_sponsor_id(converted to forename and surname from t_users) At the moment I can not join to the users table from the project table and pull back the forename and surname...
  9. davidste

    select/join problem

    The returning everything from t_proj then having to do another query based on the result set seems cumbersome thought that there may be a way to select the project info and return the managers forename/surname and sponsors forename/surname in one go that I may be missing. Seems like it should...
  10. davidste

    select/join problem

    I am currently building a projects asp application and designing the database for this. At the moment I am having problems. I have 2 tables t_proj (projects info) and t_users (user info). Projects contains projects info and users contains all the users of the app, information on the user (email...
  11. davidste

    clear text area from radio button click

    i have the following function function clearTxtRadioBtn(txtBoxRbtn) { eval("document." + txtBoxRbtn + ".value = "";") } called from onClick="clearTxtRadioBtn('form.txt_box')" in a radio button but I keep getting the following error message when the page loads error expected ')' I...
  12. davidste

    Flash ASP gotoandstop problem

    Tried the global var and it did not work i then tried looking at the flash debugger From this I have found that _level0.comments has the following vars CurrentRecord = 0 strDate = "Loading..." strFlashCookie = "Loading..." strNotes = "Loading..." strPosition...
  13. davidste

    Flash ASP gotoandstop problem

    Think it must be this line that is giving me the problem: if (strFlashCookie == "beenSeen") { gotoAndStop(form); } I have tried if (strDate = 23/02/2004) { gotoAndStop(73); } Using another of the vars passed in and it works everytime. Still do not know why the previous does not work though.
  14. davidste

    Flash ASP gotoandstop problem

    I have a Flash movie that pulls in variables from an access database and also a cookie value. My problem is that before I display the records from the DB an animation is run that I only want the user to see once. I have done this by checking a cookie value pulling the value in to flash and...
  15. davidste

    return value from function

    I want to create a function that I can call to set the style of a web page. Basically if the cookie equals medium then use a style sheet with medium text sizes and so on. So far I have function requestCookie (cookie) dim pageStyle pageStyle = request.cookies("" & cookie & "")...

Part and Inventory Search

Back
Top