i want to display the last 30 (form 01-08-2005 to 30-08-2005) days post onto the page , how do i achieve this using query, OR it will be better if the query display current month's post only(i.e. today is 3rd august ,so it should only display 3 days post!)
here is the psuodo code for....
"select * from tablename where fldDate between=" date - 30 "
So, when my search returns the result I need one of the fields to be clickable and show the customer's info for the clicked customer.So, lets say we make the ID clickable. So, my HTML has to look like:Code:
<input type = "submit" value="sqlrs("ID")">
How do I construct that in ASP since, using " in strings ends it and same with Response.write methods.
I am creating student website and wants to create some featuer like if user come on my side and type his/her student id in provided SEARCH FIELD [TEXT BOX] that page will display perticular information of that user but before that it will ask for login name and password as well. I am making my website in XHTML [front end], JAVA SCRIPT[validation], ASP [server coding], IIS server.
I am trying to create a user administration section and I want to use a subroutine that connects to a database, runs a query, returns a result and then closes the database connection. Then I would like to be able to access this result e.g a COUNT of fields in a table, in other pages.
Is this possible using Subroutines, if so how, and what other ways do you guys use code reuse in ASP?
How do I write the code for a button that will call a function/procedure in ASP and delete all records in an array? Should I use a function or procedure? Anyone who would like to finish this code? Code:
I'm a beginner with asp but i have an asp page that returns all the names and email addresses of people that i have stored in my database.It returns it in table format.This is all working fine - im using an ms access database. heres the code: ...
i have a query that runs fine in oracle, but when i try and run it through my code i get an error :
Microsoft OLE DB Provider for ODBC Drivers error '80040e31' [Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation
/test/WO_Metrics.asp, line 129
i know that it has to do with the way my query is coded, i think maybe with the nested query. because it worked fine before i put the nested query in. is there a special way to handle nested queries in aps? Code:
I have a problem with my INSERT query, I have tblDueDates, tblClient and three main forms.……..but I get errors when trying to insert payments. I have tblClient and tblDueDates and 1.frmDueDates, to insert and display the due dates for the payments ,
2.frmPayDateList in order to display the Due Dates of all clients in a list according to their due dates and 3.frmClientsPayedrecord, to see the payments of each client after the user clicked on the ‘payed’ button on the 2.frmPayDateList form. Form frmDueDates and frmClientsPayrecord are linked to tblDueDates.
But I get an error when clicking on that ‘payed’ button on the frmPayDateList. I use an INSERT query to insert the payments into that one table tblDueDates and also it should avoid duplication with this query and it’s where clause!!!!
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
In Access you use "*" + [passed variable] + "*", + can be replaced with & Calling a parameterized query in Access requires % be used in place of *, however, all that I have read show dynamic SQL passed to Access:
WHERE [some column] LIKE '" & ASPvar & "' % ORDER BY ...
However, my call is similar to:
conn.qMyLookup strVar, rs
If I modify the query in Access to:
"%" & [passed variable] & "%"
I get all records. If I only put it at the end, as suggested, I only get matches at the end, not throughout the column. Code:
i am having a problem with ASP not doing the requestion action of Response.Write based on conditions of a code entered on a first page. The codes are below. I made the second page from template of another that yall helped me with and it aint working.. Code:
Was curious if someone could help me out. I'm setting up a website and using Server side includes to make it easier for maintaining. I've got a contact form that will be included on several pages and I need to know from what page the forms is getting posted from. If I can figure out how to pass one value to a hidden field I can use the form as an include instead of hard coding the whole form into each page.
Ideally the value to be passed could be coded into each page then asp could pick it up and insert it into the hidden field. Any one point me in the right direction for accomplishing this. I don't have a clue about asp other than the basic include statement.
May i know isit can use asp to send an automail when customer fill up the registration form. i need to send a automail to his email verify the customer details. is it any free source code to write?
Since ASP server scripts use VBScript by default, does it mean it is redundant to put the following in ASP page? Then when do we need to use this? In client-side VBScript?
I want to be able to write a gif in my ASP app. Not even sure if it is possible with response.write. I want to replace the 'Member Log In' text with XXX.gif, and still have it linked to login.asp....
I am trying to retrieve info from database and display it in the form. The problem I having is when I try to change the info in the form, it is not changing and I don't know why. table.fieldname = payroll
Code:
payroll = rs("payroll") If payroll = "something" Then payroll = "Some Payroll" End If
In the form table: <input type="text" name="payroll" value=<%response.write(payroll)%>>
I want "Some Payroll" to be displayed in the form instead of "Something".
<% username = Session("username") if ("" = username) Then Response.redirect "login.asp" response.Write("Sorry, you are not logged in.") response.End End if %>
How do i write that Sorry, you are not logged in ... to the login.asp?
I've tried using a FSO to write to it directly. I've even managed to write a script for windows scripting host and invoke it from ASP, using standard output redirection (">") to redirect output to a file with no problems.
However, I can't seem to send writes to LPT2: from ASP, even through the other script.
It works perfectly fine if I invoke the WSH script at a command prompt using precisely the same command line, but when I do it from inside an ASP page, I get nothing.
Are there some permissions for the port I have to set or some such? I honestly have no idea how to get it to work.
If it is relevant, LPT2: is a mapped port for a network printer.
Yes, this is related to my previous thread, but I'm down to a much, much more specific problem.
I am trying to check for the final sql statement before passing it to a database. I want to build the statement using user input in three text boxes. However, the sql statement does not give me the right statement. Instead it gives the following message: Error Type: Request object, ASP 0102 (0x80004005) The function expects a string as input. /sailors/loginverification1.asp, line 14 CODE: <% strSQL = "select PeopleNameFirst, PeopleNameLast, PeopleClubCode from People where " & _ "PeopleNameFirst ='" & Request.Form(txtFirstName) & "' AND " & _ "PeopleNameLat ='" & Request.Form(txtLastName) & "' AND " & _ "PeopleClubCode ='" & Request.Form(txtPassword) & "'" Response.Write strSQL %>