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?

View Replies

ADVERTISEMENT

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

View Replies View Related

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.

View Replies View Related

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

%>

View Replies View Related

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

View Replies View Related

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:

View Replies View Related

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")

View Replies View Related

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.

View Replies View Related

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

View Replies View Related

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.

View Replies View Related

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:

View Replies View Related

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

View Replies View Related

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 & "'"

View Replies View Related

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'

View Replies View Related

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 Related

If 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:

View Replies View Related

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.....

View Replies View Related

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.

View Replies View Related

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?

View Replies View Related

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 Related

If/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.

View Replies View Related

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.

View Replies View Related

If Statement

I am currently trying to use the code below to write N if there is nothing in the "HomeScore" field and Y if there is, but this code isn't working

Code:

<% if rsHomeT("HomeScore") = null then response.write("N") else response.write("Y")%>

View Replies View Related

If Statement

I have the following SQL query which looks at the current date, and displays the next closest date that is recorded within my database. The code for it is below:-

Code:

strSQL = "SELECT TOP 1 events.EventTitle, events.eventdateformatted, events.eventURL, events.eventdate FROM events WHERE eventdateformatted>Now() ORDER BY events.eventdateformatted;"

Now the problem is that when there are no other future dates recorded within the database, an error appears saying just that. Is there a way I can use an If statement to say, 'Depending on the current date, if there are no future dates, display "There are currently no other future events that we will be displaying at"'

View Replies View Related

Statement

I'm trying to write a statement that says if a course code is between a particular range and a field is null, then a certain page should be displayed: Code:

if eval(coursecode) >= 24 and eval(coursecode) <= 44 then
if rs("ce_has_degree") = null then
redirectline = "supplemental_form.asp?filekey=" & filekey
response.redirect redirectline
end if
end if

I don't get an error, but I also don't get the supplemental_form.asp page. Can someone tell me what I'm doing wrong? I seem to have a horrible time getting nulls to work properly.

View Replies View Related

Say OR In An If/then Statement

if (condition) is true OR (condition) is true THEN. Can I use OR or do ihave to break it down into an elseif statement? I tried OR but it does not seem to work.

View Replies View Related

IF Statement

How can I make an IF statement to check the domain name a user has entered to access a website?

We have a website that has 3 different domain names associated with it and I need to change some of the content based on which domain the user enters to get the page.

View Replies View Related

Like Statement

I am using Access 2003 and am trying to use a LIKE statement in the criteria. I am using Like 'Mental%' and when I run it, Access sticks the letter N in front of the 'Mental. Why does it do that?

View Replies View Related

If Statement

How do i write and if statement which looks for the existance of a cookie and and absence of a session var ie:

If (request.Cookie("myCookie")) And (!Session("myCookie")) Then .......

View Replies View Related

Statement

<% if rs2.EOF AND rs2.BOF then response.write("The search returns" + "rs2.Fields("NUMBER").value" + "results.") end if%>

how can i make it work?it gives me an error? cos of the () i tink can any1 help me?

View Replies View Related

If Statement

I'need to redirect to different pages depending on user input. Below is the code I've been working with and I cant seem to get ti right.

<input type="hidden" name="loantype" value="<%=loantype%>">
<%
Dim loantype, homePurchase, data, default
if loantype value = homePurchase then
response.redirect "data.asp"
else
response.redirect "default.asp"
end if
%>

View Replies View Related

If Statement

I'm trying to write an if statement. i have two field, Status and Attendance.

"status" value can be active or inactive
"Attendance" value is active or blank

i wanted to right an if statement in which

if Status=("inactive")
response.write("N/A")

elseif Status=attendance
response.write("Attended")
else
response.write("No Show")

View Replies View Related

Add IF Statement

I want to add a IF statement in the following replace function.Here it is:

function replaceQuote(strContent)
Dim strTemp

strTemp = replace(strContent," Quote: ","<center><table width=710><TR bgcolor=""FFFF99""><TD><font face=""Arial"" size=2><i><b>")
replaceQuote = replace(strTemp," ","</i></b></Span></TD></TR></table></center><br>")
end function

I want a if statement to check there is a open quote tag and a close quote tag. If both tags are exist, then do the replace. Else do other.

View Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved