i'm trying to pass a Request.QueryString("date") in an SQL statement like this:
sql = "SELECT COUNT(*) AS sum FROM logs_main WHERE Termination='OK' AND CallDate >"& Request.QueryString("date") &""
When i explicity write CallDate >'2006/12/01' it is OK
But when i use the above code ,where e.g date value is 2006/12/01, then it doesn't work.
How can i pass a date in an sql query??
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.
I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:
I would like to pass the value %%LAST_NAME%% to another asp document.... I
wanted to pass this value by doing a response.redirect, but, it truncates the
double percentage signs
I know it works on a SUBMIT
example:
<form>
<input type=text name="lname" value="%%LAST_NAME%%">
</form>
but, I would like to skip the submit and do a response.redirect...
even if I create a variable using 'server.urlencode' it still truncates the %%
example: response.redirect "newfile.asp?lname=%%LAST_NAME%%"
I'm trying to add a variable to the url that is going to be sent but when it is sent my additions are removed! I've tried numberous variations of action="caldelete.asp?curid=<%=iRecord%>" and every time it removes everything! What am I doing wrong? Code:
View Replies View RelatedDose anyone know how to pass more than one value in a Go to Detail Page? The code I have so far is this... Code:
<A HREF="advertiser-basic-keyword-detail.asp?<%= MM_keepForm & MM_joinChar(MM_keepForm) & "TimberSpecies=" & Recordset1.Fields.Item("TimberSpecies").Value %>">Edit</A>
The code above passes the value of the "TimberSpecies" to the next page. I would also like to pass the value of the "CategoryTitle" to the next page at the same time.
The "CategoryTitle" is also in Recordset1.
How can i pass value from drop down list in 1 page to another pagei used onsubmit when i click the value in the drop down list and use request in another page to get the data.but why it still cannot works
View Replies View RelatedI’ve used java script in my asp page for the new windows utility and also for link to .js extension (get calendar). Ok let see what I’ve done…. Within elseif : (see asp comment within coding page).
IM – date – open
IM – date – close
IM – date – all
What is a problem now, I try to test for calendar function (java script) in “– IM – date – all “.
I can retrieve date from javascript file -> ‘date-picker.js’ and insert date into these two textbox, but when I want to send/pass these two values (click button continue) to next asp page called byDateIMA.asp, browser told me that ‘error on page’. I’ve no idea about this problem. Hope anyone can help to solve this problem.
I'm trying to make my site as dymanic as possible. Code:
View Replies View Relatedi'm new here and i'd like to ask if there's someone who knows how to compare date() function and date from database with date/time type inside select statement so i don't have to do if..then..else
View Replies View RelatedI have a simple form with a textbox, a combobox and a submit button. I want to also be able to pass the "values" of the textbox and the combobox in the URL. How do I do that? DO I need to set that up in the function? I know this must be simple becuase I can not find any information on how to do it.
View Replies View RelatedI want to pass the value of the cookie created in VB to ASP. This doesn't work. Any idea?
<script language=vbscript>
document.cookie="mycookie" ' also tried with
document.cookie="name=mycookie"
</script>
<%
z=request.cookies("mycookie")
response.write(z)
%>
....
Has anyone had or heard of IIS not passing emails or SSL connections, thereby disconnecting or making the server useless?
I had a virus that seems to have done this.
I am using this code to display a dropdown list of employees
How do i pass the selected name to another page, all i need to pass is emp_id? Code:
how do you go about passing a name on after a login->doLogin->MembersArea so that you can print Welcome username?
View Replies View RelatedI want to pass the value to two frames and two pages after hitting the
submit button If my form I have this:
<form method="get" action="search2.asp" target="fSearch2">
I want to pass crPN to below as well
action="search3.asp" target="fSearch3"
I am having a little problem figuring this out.
In ASP, when we pass data between pages, we usually pass by query string. If
we pass data by query string, that means we need to use submit button, not
by regular button, and the form will pass to the server since it's GET or
POST request. But if just form-to-form communication, why we need to send
the form to the server?
<form action="process.asp" method="get">
//form controls
<input type="submit">
</form>
For example, http://www.myserver.com?id=100&name=joe
Form.QueryString("id")
Form.QueryString("name")
I want to pass 2 auguments to this command like below, but the red line of following java script (server side) doesn't work, which means it doesn't took siteid and whosent vaule.
<%
siteid = Request.QueryString("SiteID");
whosent= Request.QueryString("WhoSent");
objShell = Server.CreateObject("WScript.Shell");
objShell.Run("cmd /c call rsh host -l username lockunlockRSL.sh siteid whosent", 1, 1);
%>
Does anyone know how to pass 2 varible siteid and whosent value to this command if not use batch file?
How to pass a collection from a VB Component to an ASP page? I have no clue
the syntax of all. Code:
A fill in a form which is "request.asp", then submit to "department A" to wait for approvement. for "request.asp", i use simple method "request.form()" to pass value to another page.
ques. 1:when "staff A" want to pass the form to "department A", how should i do this? store the form's data in database? then system automatically retrieve the data and trigger an email to "department A"? this look like similar to email notification, is it? any sample coding?please take note that "department A" should able to add new remarks inthe form, a new problem. how can i do it? (cos need to add new textarea/textfield)
after "department A" add remarks into the form then submit to another department which is "department B"."department B" will check and add comment to this form then keep record of this form. i'm using sql server as database.
I have a page that calls a multiple frames page (ASP).
I need to send parameters from the first to the multi frames page.
If sending to a simple page, it works. If sending to multiple frames
page, it does not.
I have this statement that passes a variable to another page. how can i incorporate another variable called teamId. I want to pass two variables at the same time.Code:
Response.Write " <TD width=100 style=border-style:none; border-width:medium; bgcolor=" & BGColor & "><p align=center><font size=2><B><A HREF=Schedule.asp?LeagueID=" & rst.fields("Leaguetype").value & ">" _
& rst.Fields("Tournament_Description").Value & "</B></font></TD>" & VbCrLf
Could anyone provide a link to a site where they go over different types of methods to pass variables?
I woudl like to know why querystrings and numbers are used to pass requests ?
E.g. in this forum, sitepoints; to display asp pages, they used forumdisplay.php?f=148
whats wrong in using
forumdisplay.php?f=asp ?
I was wondering if there's a piece of code that will do the following:- When the user closes the database, I want to pass the current date and time into a field in the database!
View Replies View Relatedbelow is my code retriveing news from table...and pronting with link..now i want to pass newsid along with this links..collecting news one place and passing it to another place
how to do ? used array to display only 10 words of news string. Code:
I'm trying to add a variable to the url that is going to be sent but when it is sent my additions are removed! I've tried numberous variations of action="caldelete.asp?curid="<%=iRecord%> and every time it removes everything! What am I doing wrong? Code:
View Replies View Relatedtell how to make this work
Response.Write "<a href=""orderdetails.asp?transid=" & objPagingRS("Transaction_Id") & """>"
i want to pass 2 more variables like orderid and customerid through this querystring
I have a function called GetRS which takes in a SQL string and returns a recordset object. Does this mean that a copy of the recordset is returned or is it passed by reference?Obviously this could have a large impact on performance for large recordsets.
View Replies View Relatedi am opening an excel file in the same explorer window as the form. i am storing values entered in excel in database. while saving the field in the db i need to save a field from the form also.how can i get a form value inside the vba code or to put it like thishow can i refer the form value inside excel?i m simply opening a template of excel file.
View Replies View RelatedI have a link www.example.com/survey.asp?usr=[username]&pwd=[password]
survey.asp is going to be a redirection that redirects to one of these random links;
www.example.com/survey1.asp?usr=[username]&pwd=[password]
www.example.com/survey2.asp?usr=[username]&pwd=[password]
www.example.com/survey3.asp?usr=[username]&pwd=[password]
www.example.com/survey4.asp?usr=[username]&pwd=[password]
I need to pass what ever is in the [username] and in the [password] fields too.As the [username] and [password] would be unique for each url (as I will be emailing 1000's out which will be email-merged)
for example if the original url is; www.example.com/survey.asp?usr=abcd&pwd=1234 then it may redirect to: www.example.com/survey1.asp?usr=abcd&pwd=1234
I have a form which submits it's data to a hidden page(submit.asp).Submit.asp retrieves the data and submits to the db.Immediately once it has submitted data,it will then retrieve the auto generated id for the data just submitted.(hope this will work)
Once I have retrievd the auto gen id, I want to then pass this id to *another page*. I don't want to then create the table on the submit.asp page as there is a huge amount of code there already-want to keep things clean.
How do I pass the value to another asp page?Is it something like response.redirect and how do I attach the id?
I need to pass a variable in a URL to set up a dynamic page where the content shown is based on the recordet queried on the value passed in the URL.So when the user pulls down a menu list and clicks on Todler Clothes, I need it to go to URL store.asp and pass the choice of Tolder clothes in the URL variable.
Then I need to have my recordset query (WA Querry Builder) use that variable to pull the correct items from the db.How do I add the variable to the URL and what is the ASP statement to get it.
I am using Crystal v7. Main report and subreport are both based on the same stored procedure. How do I pass parameters to display the report and subreport in the Crystal viewer. I can display regular (non-sub) reports fine.
View Replies View Relatedi need to modify one website. in this website we use activex control to get data from local computer. after selecting that data on the basis of selection i need to run query and get value. i need to use this value in javascript which is called when i click button.
i faced problem because i am not getting this value in javascript. which i need to get it from database on the base of userselection. we use simple button in stead of submit. so is there any way i can get this value in javascript. when i click the button.