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()...
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()...
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'.
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...
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...
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...
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)...
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...
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...
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...
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...
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...
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.
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...
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 & "")...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.