I 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 RepliesI 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 Replies View Relatedi'm going to ask the way to use database to check user permission level in asp..
View Replies View RelatedI 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 RelatedIs there a way whereby i can detect where the user came from?
For example:
if this user came from www.mywebsite.com/a.asp theni will redirect him to c.asp but if he came from www.mywebsite.com/b.asp then i will redirect him to d.asp
I'm developing a web page in ASP that can detect client's machine name & windows user name, but can't been able to do so.I'm using VBScript as scripting language. I've used ServerVariables(LOGON_USER) & REMOTE_HOST Also but of no use. Can ny one tell me how to do it. Code:
View Replies View RelatedI am using the following code which works if there is records, if there is not it shows blank screen, how do I make a message show if there were no records found? Code:
View Replies View Relateddoes anyone know some code to be able to divert mobile phone users to a different site (wap version) clicking on the same link as a pc user would.I have been able to get the browser by using Request.ServerVariables("http_user_agent")Though it is only mobiles that i want to divert else where (this does not include PDA's).I'm guessing it is via an 'IF' statement but I don't know?
View Replies View RelatedIs there a way to detect if the servers domain is added to the user's trusted zone?
View Replies View RelatedCould anyone show me a tutorial or like show me a script in asp that can detect to see if the mysql backend is working? And if it isn't then to display a message that says something like "out of luck."
View Replies View Relatedhave a site with one asp page that sells a product. i have a thank you page that sells my product with a click on download.
how can i prevent a user from going to my url/tankyou.asp
and download it manually?
i want the user to download the product only in case he made it! i cannot control the sale pages as they are 3rd party credit card transactions and i do not have a database
how 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 Relatedbelow is an insert statement on an asp page that stores the date and time
that a driver logged on, what I need is to check that they are now already
logged on fields are SQL Server 2000
ID int
DRIVER_NO int
ON_DATE datetime
OFF_DATE datetime
ON_NOW nvarchar
SESSION_ID int
The ON_NOW column reads on or off depending whether the driver logged out or
not, if they havent we need to close the previous logon session and mark it
with 'off' and enter a date time into OFF_DATE column. Code:
I am creating a web-based application with ASP and using frames. I wonder how we could trace user's browsing behaviours in this particular domain. That is, I need to know which pages the user has viewed and which pages the user has not yet visited, as this information is essential and will be used to assess their learning paths and progress.
Therefore, my question is that how to create a file which stores information about users' browsing history, i.e. the page the user visited, so that we could use these information to assess users' learning progress, or what is the right means to tackle this requirements?
I need VBscript to Check if user is a member of an Active Directory Group. I read about something called "MemberOf" to check that.
View Replies View RelatedI want to add the "Did you mean" - Google feature to searches on my
website.
My website lets users search for a business using different
parameters.
If there is no match, I want to do a spell check on the entered
parameters.
I need to be able to check words with an english dictionary as well as
add words(business names) to the dictionary. Code:
I have the following line of code in an asp.net app?
Response.Write("<script>ret = confirm('Print Orders?');</script>")
How can I check the value of the variable ret in asp.net? I want to be able to check the repsonse from the user before continuing with my asp.net code. Is this possible, or am I going about this the wrong way?
I made an asp that I insert records in an MS Access Database. I do insert them allright. But I want to check before inserting if this customer already exists. I try to do that by checking lastname and name (p_eponimo and p_onoma) but seems not to work ....
View Replies View RelatedI need to check to see if the Current logged in user on the system
is a member of a group called CustAdmin on CustNT Domain.
If the user is, I need to allow them to have access to the following:
Code:
<br><br>
<input type=Button value = "Click To View Credit Report"
</form>
<hr>
This is a Windows 2000 network.
write a simple function to check the user input from a form. I need to check that the string contains only numbers, has a maximum leght of say 15 and that the first number is zero.
View Replies View RelatedI'm trying to pull the last 5 records from my database.
<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here
<%rs_article.MovePrevious
j=j-1
Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
By using <authentication mode="Forms" > in web.config, we can create
self-designed login page, but how to check user's account and password is
vaild in another domain controller?
Does <authentication mode="Windows"> can have self-designed login page?
I have a Golf leaderboard based on points given to each player after each match. That works fin, but is it possible to show everys players record after his or hers name. At the time it looks like this.
Mike 7,50
Peter 5,45
etc.
My code is like this Code:
how asp script when I want to check two different tables in database if data in table in different
example:
in table sent_sms where status sent but no receive_sms, i want insert status in status "Not OK"
i am getting a prob. in database id is a autonumber .i want to update value after retriving the va,lue from database .that is going on i mean retriving valuue from database but not update. Code:
View Replies View RelatedI have setup a database for user to upload product image and it name and desciption. Since there is no product upload by user, it will display this error:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/i-Metz/iMetzAdminADs.asp, line 295
Therefore i wrote this script to counter the error:
there is any way i can check if the database Exists. I mean from the code side. I dont want it to throw me any error thats the reason.
View Replies View RelatedI have to check wether the database connection is opened or not.I am using ASP with sql server database.
I can open connection and do all the transaction with the database,when multiple users are connected to that same sql server instance,i got an error like sql server not exist or access denide.So i want to check my status of the connection.
Now i got problem in my ASP page using VBScript that is implemented for IP Phone Service.I am trying to do directory service in IP Phone.So user key in the first name or last name.
According to user input, it will go n look for the name in MySQL database.If the name is not found,it will return the error.My VBscript programming is bad.I cant check it out how i check the return for Record set from database. Code:
How can i check if a vlaue exists ? Sample to get the idea: Code:
set con=server.createobject("adodb.connection")
con.open "Menu1"
sTempquery ="Select * FROM Voorkeur Where gebruikersnaam = '"& Request.Servervariables("LOGON_USER") &"'"
Set autor=Server.CreateObject("adodb.recordset")
autor.Open STempquery, Con
The idea is that if the "LOGON_USER" does not exist in the Dbase he must execute code. How can i do that?
I have a directory website which is having more than 20000 company details. Anyone can search the directory for the company. Everything works fine, but if someone misspells the word it returns 0 company found.
So i want to add a spell checker to the word user types in the textbox to the companies in the Access database. I need something similar to the google search.
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 Related