Reuse SQL Statement In Different Locations
If I have a complex SQL statement that I want to use on several pages, what's the best way of going about it? Do I put it in an include or should it go in a sub or function or something else?
View Replies
ADVERTISEMENT
Reuse Of A SQL Statment
I have a sql statement that pulls up a certain amount of records according to a requirement. Let's say that 20 records show up. I want to get to the 5th one. Well now I know that I can use the move() function to enable that, but it is the same page.
The page executes the sql statement and by default shows the last record in the query. Now when I ask for the 5th record the page is reloaded, the sql statement exectures AGAIN and the 5th record shows up. Is there way to ask for the 5th record without having to re-executing the SQL statement?
Session Reuse
The application is an ASP app using a Sql Server 2000 back end, w/ IIS 5.5. It uses NT authentication. We use BigIP for load balancing across 4 servers, and have enabled active cookies for state maintenance w/in BigIP. An employee_ID and some other basic identifying info is stored in the cookie.
After significant log file and SQL Server Trace review, I've determined that the application is reusing existing sessions and their stored information when it
shouldn't. What happens is that a user logs in and works for a while under a session id. At some point, a second, new, session ID is created for them. At this point, if another user logs in, they (may) be using the original users first session ID, with all of the original users identifying info. I haven't been able to isolate exactly what causes the new ID to be created in the first place, it isn't consistent. Obviously, this causes all sorts of problems, "turning one person into another" as the users say.
I'm at a loss. With the session ID tracing back to a different user, all the normal ways to ID the logged in user -- like the Logon_User server variable -- trace to the wrong person. I have determined that IIS logs the cs_Username for the user that's really sitting at the computer, the "correct" user. If I could find a way within the ASP code to pick up that cs_Username, I could circumvent the problem by modifying the session state check include file, but I've had no luck.
Session Reuse
Is there any method to check existing session objects for a session object containing user say for eg "XYZ"
The requirement is to reuse the session object if a user failed to logout and is trying to login again from a different machine or a new browser window.
I donot wish to store this info in db. if the session exists i wd just use it rather than create a new one.
Redirect To 2 Locations
How can I redirect user to two different locations using single Response.Redirect
View Replies View RelatedFileExists For Networked Locations
I have been messing with FSO.FileExists for a while and have been looking into its limitations. On our server, we operate our directory in:
d:inetpubwwwrootintranet
and inside that directory is a VIRTUAL DIRECTORY by the name of employeeImages which maps to
otherserverfolder
So saying
d:inetpubwwwrootintranetemployeeImagesfile.jpg
IS the same thing as saying
otherserverfolderfile.jpg
The problem is, that when I set that path to a variable, called strPath and perform the following:
blnExists = FSO.FileExists(strPath)
it KEEPS returning as FALSE. So I had it output strPath. Sure enough it was the URL shown above. I cut and paste that into a window's location bar and boom, I'm taken RIGHT to the image.
So I'm thinking "Ok, FSO is a FILE SYSTEM OBJECT. Maybe it's limitations mean that it can only look at the local filesystem? Maybe it cannot see across a networked device? Maybe it cannot work with virtual directories?" I've done some looking around and cannot find any pages on limitations of FSO.
XML Server.map Won't Take Remote Locations
Whenever i put in a remote location to server.map, it errors about an invalid character (the colon is what gets it. is there any way to do xml parsing remotely?
View Replies View RelatedDifferent Recipient For Different Geographic Locations
I've been using aspmailer by Tom Germain but I don't understand how to get it to do this (or find another mailer script that will) - assign different recipient email addresses for different geographic locations, then process accordingly, depending on the geographic location selected from list on form.
View Replies View RelatedForm Have Two POST Locations
Is it possible to POST a FORM to multiple URLS at the same time OR Is the only workaround for this scenario to use response.redirect in the called ASP page and do a multi processing?
View Replies View RelatedASP Mail, Toggle To Send Form To Different Locations
I have a simple aspmail form on a site I'm getting ready to launch, and the client has several locations... I wanted the user to be able to choose the location from a pulldown that the form was e-mailed to. Do I have to have a backend processing page for each location and have the pulldown point to it?
View Replies View RelatedGet All Records, But Display On Separate Locations On Page
I have a table with a number of 'advertisements', and each ad specifies a page display location (#1 - #9). I would like to query for all ads, but display them only where they have their location (see image above). I currently have 9 different SQL queries, one for each location:
"SELECT * FROM tb_ads WHERE f_adlocation = 1
I would like to have one query, and at location 1, simply say: "If f_adlocation = 1, then display here. If there is more than one, then repeat as necessary". Here is what my database looks like: I have attached sample data as a .txt file.
If Statement
If a user enters in this to search a db
"Jon Doe" James Doh
return all of the exact matches Jon Doe (user uses quotes to clarify an exact search)
along with that: return all of the James and all of the Doh as well
qry to look like this as soon as I am able to divide up the string entered in by the user
select * from table where (NAME LIKE '%Jon Doe%') or
(NAME LIKE '%James%') or (NAME LIKE '%Doh%')
Thinking of using the instr to find the " but then what do I do to find the string inside of the two quotes, One quote would be easy. there is a couple of checks to preform:anyone run into this before or have any ideas/samples, etc
Sql Statement ?
I have created a query wizard page with ddl as your choice to find info. now each ddl has a default of a dash.
The thing is I want to do is have the sql statement to look through the database even when some of the ddl have a dash on them. or just ignore the ones with a dash and look for the ones that are selected. Is there any suggestions for this.
ASP If Statement
Below is my code for a question system i have created. However, i need to insert an if statement that redirects the user to test.asp if the value of q_id is not in my database, but i dont know how to do it?
<%
q_id = request("q_id")
sql = "SELECT * FROM questions WHERE PARENT_ID = 1"
Set objRS2 = Server.CreateObject("ADODB.Recordset")
objRS2.Open sql, objConn
sql_sql = "SELECT * FROM questions WHERE PARENT_ID = " & q_id
Set objRS3 = Server.CreateObject("ADODB.Recordset")
objRS3.Open sql_sql, objConn
%>
AND Statement
my AND statement is not working and I dont know why????
sql = "SELECT * FROM calls WHERE tech=" & userID "AND status = Open"
tech and status are the DB fields
userID is a variable
Open is just a word
If..Else Statement
i make a form with an AccountId box on it , when u enter the accountid in the box , and submit it will send u to a page that show u all the data for this accountid(retreive data)
until here everything is ok , and when i enter for ex. accountid : 5 , all the aacountid fiel data will be show to me , but the problem when i enter am unvalid accountid , it will give the error page that
what iwant to do that i want when i enter an unvaildaccountid an error text show to me like
response.write("The Id that u entered is unvaild , Try Again")
and this is the code , if u can change on it Code:
IF Statement
I am trying to use the following IF statement, and whenever I use a
single or double quote, I receive a syntax error. When using no
quotes, the syntax is accepted, but the statement does not perform
properly.
***The problem line***
<% if violation_type=''Tardy'' THEN %>
***rest of the statement***
TARDY VIOLATIONS
<% if rs2.Fields(0) = 0 THEN %>
This is the first unexcused Tardy violation for this employee. A
coaching is required. Click <A HREF=blah>HERE</Ato issue the
coaching.
<% ELSE %>
This employee has <%response.write(rs2.Fields(0))%previous
violations.
<% END IF %>
<% ELSE %>
The <%response.write(violation_type)%violation has been recorded.
<% END IF %>
Variables defined:
violation_type = request.form("violation_type")
If/Then Statement
On a page with a form (post method) and a hidden field "Process value = true", why would this statement not work:
<%
if request.Form("Process") = "true" THEN
The code in here sends an email to the user via CDOSYS
End IF
%>
This is what I have going on and it does not send the emal when the form is posted. Removing the If statement obviously sends the email the moment the form page is accessed, but thats not right.
Statement Not Following
i have a couple of if statements and it goes something like this, the user will try entering their username and password in the login page then they will be taken to a verify page, then it will decided if the user can be send to the login page again or to the invalid page. The problem is that after 3 times the user is still send to the login page and not the invalid page My verify page code is :-
<%
session("try") = try
if try = "" then
try = 0
else
try = try + 1
end if
if try <> 3 then
response.redirect("login.asp")
else
response.redirect("invalid.asp")
end if
My Sql Statement
Recordset1.Source = "SELECT `bestsellerslists`.`itemnumber`, `bestsellerslists`.`list`, `products`.`Product_ID`, `products`.`Product_Name`, `products`.`Price`, `products`.`Sale_Price`, `products`.`Smallpic` FROM `bestsellerslists` INNER JOIN `products` ON (`bestsellerslists`.`itemnumber` = `products`.`Product_ID`) WHERE (`bestsellerslists`.`list` = "girlinfant")"
In Macromedia, the recordset tests fine. When I start the page, I get an error. Do you see anything wrong with this? If I delete the WHERE clause it works.
If Statement
I'm having a problem with my variables. They print to screen fine, but when I try comparing them, they don't work. Can anyone tell me what I'm doing wrong?
If Category <> CurrentCategory then
response.write "<tr><td>Category:" & Category & "</td></tr>"
response.write "<tr><td>CurCategory:" & CurrentCategory & "</td></tr>"
else
response.write "<tr><td>hello</td></tr>"
End If
Code:
If Statement
I am passing in values either customer id (key) or their names (name) from a form .
You don't have to use both the id and the name to search for the customer however I don't know how to do this!
If the keyform = "" then , use the name to find the customer
else
can't find it! this is what I have at the moment :
keyForm = Trim(request("key"))
name Form = Trim(request("name "))
Dim name , cyfeiriad, tref, sir, codpost, ebost, ffon, cyfrif, dyddiad
Set dnsSQL = g_con.Execute("SELECT key_user_accounts,name ,cyfeiriad,tref,sir,codpost,ebost,ffon,cyfrif,dydd iadcreucyfrif from cwsmeriaid Where key_user_accounts = " & keyForm & "
if not name = "" then and name = '" & nameForm & "'")
else ")
end if
End Of Statement
ii am using a statement to send a query to the SQL server and i am getting errors like expected end of statement.
what might be the problem and do i use a statement like this for dynamically assign values or it's better to use stored procedures.
dim mySQL="Select * from logindetails where loginname='" & logname & "'"
SQL - Like Statement
what am i doing wrong:
SELECT * FROM Tablename WHERE Content LIKE '%Netcapa%';
this is the error im getting
ADODB.Recordset error '800a0bb9'
SQL Statement How To Do It
I was wondering how do you arite an SQL statement that only displays the list of projects from the last 30 days (i do have a date field as well)
View Replies View RelatedIf Statement
I have this code:
<%=strContent%><br><%=getData("News", "TOP 5 *", 1, 0, "News_title", "News_Date", "News_Id", "news.asp", "100%")%>
which brings back news data from the db
how can I write an IF statement to check if the news page is displaying an id and if it so not display the code... ie Code:
If.. Else.. Statement
I'm fairly new to coding in asp and i'm trying to create a simple if.. else... condition.
It's for asp web page, and is linked to my database, but i figured since it's a basic question, it would belong in the General newsgroup.
All i am trying to, is, on my web page I have a table cell, that feeds off my database.
If there's something in the database in that particular field, then I want it to be displayed, If not, then rather the cell return a blank field, I want a picture from another field.....
IF Statement
How can I do the following:
If recordset is empty, redirect to page1 but if recordset has something in,
redirect to page 2.
IF Statement
How can I use an "IF" statement to decide what to write depending on the content of a field. I've usually been just designing my database around using
if isnull(rs_events.Fields.Item("f_register")) then response.write("")
But I would like to change my current schemas so that I can make a smaller database, so that
if (rs_events.Fields.Item("f_register")) = "Yes" then response.write("Yes") else response.write("No")
How can I acheive this?
If Statement
I'm trying to write an if statement that shows a message if there are no records to display that match my select statement:
employment_op.Source = "SELECT Employment_Display, Employment_Link, Employment_ID, Employment_Category, Employment_Position_Title, Employment_Qualifications, Employment_Description, Employment_Application_Details FROM dbo.hr_employment_opportunities WHERE Employment_Display = '1' AND Employment_Category = 'Staff' ORDER BY Employment_Position_Title"
I was trying to use
<%
if employment_op_numRows = 0 then
response.write "No Current Openings"
end if
%>
Which doesn't return anything - can somone please tell me what I'm doing wrong?
LIKE Statement
In an sql query in my asp page, how do i find all records that have the word ERROR: in the first part of it?
View Replies View RelatedIf/Then Statement
I have been screwing with this for over 1 week now.The only time this works,is when the if statement is at the very top of the page.This presents a whole new problem because now I can't grab the variable from the recordset and I need to get it from a hidden field "request.QueryString.
How can I pass the users email address variable from a hidden field to the CALL statement without anyone seeing it in Source View?Quote:Originally Posted by janusz-jasinski I'm not sure what's going on in that case.I used same script and worked here.
Xsl If Statement
Ih I have part of XML as:
<HOUSES recordcount="0" />
How can I have a statement that would check if HOUSES doesn't have any items - then it would output some text?
I tried
<xsl:if test="HOUSES[RecordCount='0']">text
</xsl:if>
But it didn't work.