How To Add A Image In A If Else Statement
Response.Write "Thanks for filling in the quiz</p>"
If (total >=1 AND total <=7) Then
Response.write "<p>You are a HARDCORD PARTY ANIMAL! <p> Looks like you love your drink and going out. <p> But it seems you may have a lack off sleep but if your enjoying yourself. <p>So WHY NOT!"
ElseIf (total >=8 AND total <=10) Then
Response.write "<p>You are a PARTY ANIMAL!<p> Looks like there is a bit of life in you.<p> You enjoy a drink or two and socialising which is all good so keep the good work up!"
ElseIf (total >=11 AND total <=13) Then
Response.write "<p>You are a NORMAL GUY!<p> Looks like your just an average joe. <p>It could be worse so look at the bright side!"
ElseIf (total >=14 AND total <=15) Then
Response.write "<p>You are a COUCH POTATO! <p>Seems like you enjoy a little kip now and then. <p> So dont worry to much about it. <p> As long as your enjoying yourself."
ElseIf (total >=16 AND total <=17) Then
Response.write "<p>You are a EXTREME COUCH POTATO! <p> It seems like your on the lazy side and enjoy watching tv a lot. <p> But its all ok if your health is good."
View Replies
ADVERTISEMENT
I built a dynamic product catalog page and I need to pull from another recordset the header information. It works, except when it's undefined.
I tryed to write and if then statement, but it I couldn't figure out how the finish it..
If ((Recordset1.Fields.Item("HearderURL").Value) <> "") Then
Display the HeaderURL?
View Replies
View Related
I have a client who has had a ASP site with an Access database for several years. It stores information for the used cars on his lot. I have stored text in the database that points to the location of the image for each record. Each record will have a thumb image that is supposed to display in a list of vehicles available then the user can select an item from this list and a new page displays with the information and the regular size image. So far everything has worked fine exept for the display of the images which are stored in a separate directory called veh-photos. All I get are image place holders. I am using Dreamweaver 2004 and and Access 2000 for the database.
Following is the code to list vehicles: ....
View Replies
View Related
1.I want to show a image file of type '.tif' in the browser window; for that I'm writting as ASP code page.
2.This '.tif' type image can be shown better with 'Kodak Image Control'.
3.To have this 'Kodak Image Control' on my code page I just add it's ..ocx to tool box and then drag it from 'Toolbox' to the page.
4.Now after dropping this control to the code it's type is getting changed to 'object' instead of type 'ImgEdit'(and I think this is the
reason I don't get correct result).
5.On one button's 'Onclick' event I'm calling a javascript function with which I'm setting a 'Path'and'Display' property of a control.
6.And want to show a image at location -- '..MFTDRCMF919685173-62.tif' which get shown in new browser window but could not get shown in that particular control. That means the path is correct, then what is the problem?
For better understanding of problem I'm pasting a following code which I've tried up till now......
..................................................
<%@ Language=VBScript %>
<% OPTION EXPLICIT %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<SCRIPT LANGUAGE=javascript>
<!--
function showpic()
{
var path;
path = document.frmtif.path.value;
alert(path);
document.frmtif.ImgEdit1.Image =path;
document.frmtif.ImgEdit1.Display;
window.parent.self.open(path);
}
//-->
</script>
</HEAD>
<BODY bgColor=#ffe4e1>
<form name="frmtif">
The Image
<P>
<OBJECT id=ImgEdit1 style="WIDTH: 409px; HEIGHT: 218px" type="ImgEdit"
align=left
border=1 classid=clsid:6D940280-9F11-11CE-83FD-02608C3EC08A
name=imgtif></OBJECT>
<input type="hidden" name="path"
value="..MFTDRCMF919685173-62.tif">
<input type="button" name="show" value="Show" onclick="showpic();">
</P>
</form>
</BODY>
</HTML>
..................................................
View Replies
View Related
I am creating a dynamic ASP VBScript page, which gets data from an Access database.
In the database, there is a field which holds a URL to an image. I can get the image to display fine, but where there is no file that matches the URL (i.e. a missing image) I want to display an alternative, default image (e.g. one that says "Awaiting Image"). The field is never blank, but the image file may not exist for all records in the database.
I think what I am trying to get to is the following:
If file exists (using URL from database to get location of image file) then
display image using the url from the database as the image source
else
display default image - hardcoded in program
endif
I have had a go and come up with the attached but I get an error with my if statement...
View Replies
View Related
I can convert an image that is retrieved from a FileUpload object into a byte array and insert it into the database..
When the user signs-up i wish tosimply insert into the Picture (DB Type = Image) field to an image i already have saved in my images folder?
Anyone know of a way to do this? Tutorials, articles or advise??!
View Replies
View Related
Here is my code. I'm using 2 pages.
(Page 1) blob.asp
<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_blob_STRING
Recordset1.Source = "SELECT AboutPic FROM Elizabeth.GF_AboutUs"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Response.contentType = "image/jpg" 'Recordset1.Fields("AboutPic") <---Tried
both methods
size = Recordset1.Fields("AboutPic").ActualSize
blob = Recordset1.Fields("AboutPic").GetChunk(size)
Response.binarywrite(blob)
%>
(Page 2 Show the Image)
<%
Dim urlString
urlString = "?" & Request.QueryString
%>
<% Another rs to show other information as text from the same table %>
<body>
<img src="blob.asp<%=urlString%>" width="194" height="256">
</body>
View Replies
View Related
I'm working on a project where I'm suppose to upload a image to a server. The uploading works fine but when I want to change the image I uploaded to another image I can't get the filepath of the old image to show in my "filefiled"....is it possible to set a "value" where I can retrieve a filepath in a form if the input type is "file"?
View Replies
View Related
This worked fine for enlarging my images until i put it onto a secure server, anyone know how i can fix it ??? just comes up with the standard box with a red cross in it .. and the url when i click image properties says: http://url/images/<%=request.querystring( which is only part of the code)
View Replies
View Related
I'm looking for a simple way to merge an image into another image.What i have is a screenshot uploader, and i want to make it so that when they upload the SS, the script will automatically merge a small copyright type image onto the bottom right of the picture.
View Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
View Related
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
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
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
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