I have a database with two fields: product and photo. The page should display pictures of the product, which are on the photo field and if there is no picture (in this case there is no registers in the database) I need to display a message like "hey dude, no pics right now". Code:
View RepliesI am having trouble trying to detect if no records are retrieved by the search. There doesn't seem to be a problem with the connection to the database or the SQL query. I think the problem is somewhere in my If statement. Code:
View Replies View Relatedhow to check in ASP using SQL database for existing user. I have some idea like do a select but I need the syntax.
View Replies View RelatedI am building and intranet and i need to check if a file exist in a folder on the network. The folders are in the R drive, the web server is on the same network as the other servers. I have tried this code below but I can only check the files on the website.
Set fs = CreateObject("Scripting.FileSystemObject")
if fs.fileexists("filename")=true then
Response.Write "Exist"
else
response.write "Doesnt Exist"
end if
set fs = nothing
I want to know how to check if the record I am about to add already exist? I would like to refer to the field of "icno" in the database. Code:
View Replies View Relatedhow asp can check whether a variable exist or not, like exist(name), or exist(hello)
return true and false.
Is there a method where by I could check for a certain table or query
exist in my access database file before I made query to it??
I am making a news letter application for my company. The idea is that if the cookie (fictional name Frankie ) don't exist a newsletter is being sent to all subscribers.
View Replies View RelatedI have a server using a webapp built on classic ASP, and I use a library that creates/manipulates a datagrid-style display on the page.
I am displaying a large chart with sufficient data that it will likely be paged, and there are several columns that are toggles (using checkboxes for these, with the entire column having the same checkbox NAME, but different values depending on the record).
I have a piece of script that for loops through the records present on the page (determined by a collection of hidden form values), and then I need to check if the collection formed by a given column contains that value, something like the following (pseudo-code):
I am working on a college project which has a user area and a page where only a user can access their information and no one elses.I am trying to do a select statment to read specific information from a field without reading any other users info.
The code below is for a drop down menu for payment months i have stored in a database...
Here is what i have got so far...
Code:
Set oRs = Conn.Execute("SELECT [Payment_Period] FROM wages WHERE [Staff_ID]=" & staffid" ORDER BY [fullname]")
what i want to do is to put 2 fields in my table , username and password
what iwant to do is to create a page that ask you to unter your username only ,and when u click submit the other page will add new record for the username u enter and will input a randomly alpha(letters and numbers) to yr password field , so how can do this random thing throw the asp"!?!
Is it possbile to check a file exist without using Server.CreateObject("Scripting.FileSystemObject") in asp page??
The reason is our hosting company turn that function off for security
reason.
Here is my original code:
<%
Dim objFSO
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
If objFSO.FileExists ("yourfile.txt") Then
Response.Write "File exists"
Else
Response.Write "File does not exist"
End If
%>
I need to check the field for model_no first and then check the field for 20 serial no.
Is there any method for me to do?? Code:
how to check the existing serial no in database? let says the database contain 3 different serial no such as B123,B124 and B125. the problem is, when user try to key in the serial no, and just in case if the user key in the same serial no twice then one pop up message will comes out notified that record already exist and user need to +1 at the end of serial no.
View Replies View RelatedI'm listing records from my db and each company has 3 address lines ie address, address2, address3. In most cases 3 and sometimes 2 are empty. As my ASP looks like this
[VBS]
<p><strong>Address/strong> <%= rs("Address") %><br>
<%= rs("Address2") %><br>
<%= rs("Address3") %><br>
<strong>Town/strong> <%= rs("Town") %><br>
<strong>Post Code/strong><%= rs("PostCode") %><br>
<strong>Telephone/strong> <%= rs("Telephone") %>
[/VBS]
then I end up with the first line of the address and two blank lines. How could I avoid that by checking if the fields have content, only then display them?
I have a page that processes a form and one of the fields might be empty as it's optional if it gets selected or not.
In my process page I would like to check if the form field news_image is empty or not.
How would I do this?
<% If Request.Form("news_image") = "" Then %>
Is that how you do it?
is there any one know how to make function to update db field and to be called on checking a check books.
View Replies View RelatedHi everyone. I'm new to this forum and appreciate anyone's help who knows how to do this. I use ASP to mainly handle email forms. I have code that validates the email format, making sure the @ and . are in the right place, but there is a frequent problem with people submitting their email address on my forms that seem to think their email address begins with "www." (ex: www.bob112020@aol.com), which leads inevitably to bad emails in our list.
Anyone know how to automatically remove "www." from a form text field when it is found?
I run a classified ads site, and one of the features are that the user will be notifed of all new ads (at once) that are posted, everynight. At the moment the user must go to a specific page to enable this, what i would like to do is set this automatically when registering to enable.
the database uses yes and no for this feature, however i have tried entering a default value of yes, however when someone registers it shows the (-1) in the database and not the yes.
Is it possible to creat aSelf-register form on IIS? Using Widows server 2003, is ther any script needed to do so, or any extensions.
View Replies View RelatedI have this ASP page that checks if a certain DLL is registered on a client machine. If it ain't registered, then it should be registered.
Here is the part of my code that supposedly registers the dll: Code:
I need help with creating a register process for the user(Name, Password, email and phone) and then them being able to login(using name and Password)
I using ASP and access database, I'm also doing it in wap/wml but I think that if I had it in just normal html I would be able to convert it
I made a small executable file in VB, compiled it and threw it in the Bin folder of my virtual web directory, however when I try to run it from an ASP webpage I keep getting the error that it can not create the object.
After some googling everyone seems to say that you must register the .exe with the server first. My question is, how do I go about registering the .exe file with the server (I have admin access to the server) so that I can use it in my ASP webpage.
This regards a listing of youth events. I have a Access DB that users input to. A page where users can view input and the events. I use Dreamweaver to make this. When entering informaiton into the db a user would enter in the Event_Reg field the site where a person can go to register for the event. I would like to make a Link Titled "Register" for all events that users enter into the db.
But when a users clicks "Register" it would take them to the site specified in the Db Event_Reg field. Below is the dynamic code I am using now. It will produce the actual site address. I just want it to show Register when clisked take them to the appropriate site.
<%=MakeHyperlink((Recordset1.Fields.Item("Event_Reg").Value))%>
How do I register FileSystemObject and ImageGlue component with MTS? Because the files manipulated using ImageGlue & FSO need to be recorded in the database. Without transactions, a lot of 'floating' files (without entry in the database), and entries without the physical files left around on the server.
View Replies View RelatedI downloaded your "A Beginner's Guide to CDOSYS" article I
displayed the Sample1.htm page with the IE6 within
a web folder. The page display perfectly. I filledin the
e-mail info and clicked send. All worked without any error
message. I destination e-mail address never received
the mail. Do I need to setup IIS 5 first? Register it
somehow. Please advise. I'm anxious to use this built
in component.
My ISP is Comcast. My OS is Windows 2000 server Pro.
I setup the MS Outlook for outgoing mail. Outgoing mail
with MS Outlook works fine.
I have set up a login and register function in my site. When a user logs in they are re-directed to the homepage.
What i want to do is display the users name after they have logged in, on the homepage. How do i do this?
how to build a login.asp page with a session control and register.asp page with validate input value.
View Replies View Relatedi'm developing a site but i'm still new to ASP..i could only
code a simple DB [add/edit/remove] coding..
i need to creat accounts for users, so i must have a LOGIN page
contains all the standard such as: Logout, register new user,remember password ,,
users who should register in my site , are previously stored in DB by a KEY field..not to allow any user to register..a new user should only insert that key,if it is exist in my record,i shall allow him to view some pages.
I want an automatic email to send to a user when they register, the first page looks like this, i took away all the table information and what have you ....
View Replies View RelatedIf I need to check if a certain value does exist in a field, and return either "yes" or "not" which query would be the most effestive?
View Replies View RelatedHow do I find out if an url exists? Whar I want is a function like this:
If UrlExists("http://www.test.com/test.html") Then
Response.Write("Yeah!!")
Else
Response.Write("No file :-(")
End If
Can anyone help?
IS there a way I can do an If exist to determin if a graphic is displayed?
something like this;
<p align="center">
if file exist "fileone.jpg"
<img border="0" src="fileone.jpg">
if File exist "filetwo.jpg"
<img border="0" src="fileone.jpg">
</p>
What I am trying to do is post JPGs from a folder structure, the files may
or maynot be there, but I don't want to have the blank picture reference to
be displayed as if I where to just hard code the graphics in the Html!