this is my code. i want to add a new record but if the Item Number is exists, set the Session("item_exists") = True. how to that? Code:
If Request.Form("Submit") = "Save" Then
p_no = Request.Form("prod_no")
p_name = Request.Form("prod_name")
sql = "insert into Products (prodNumber, prodName)"
sql = sql & "values("&p_no&", '"&p_name&"')"
db1con.execute(sql)
Response.Redirect("supplies.asp")
End If
I want to reverse a folder listing, can I referre to a collection with a
item number like in arrays?
ex:
set fs=Server.CreateObject("Scripting.FileSystemObject")
set fo=fs.GetFolder(smp)
for each subfld in fo.subfolders
..
..
next
can I do the FOR statement reverse without putting all folder names into an
array.
I need to insert some number into database as text. My problem is if I insert the number (ie. 4.0), the value in the database only show (4). So, is it possible to convert a real number into text number using ASP?
View Replies View RelatedI have a database that holds information in many tables. I have created an "Update" and an "Insert" form in dreamweaver MX 2004 which work fine but it allows me to add duplicate names in to the database. Does anyone know of any codeto stop this. If possible i would like it to bring up a pop up saying "Client Name Already Exists" etc
View Replies View RelatedCan I do this is ASP
I would like to check for the existence of a dBASE table but I am not sure about the syntax
here is the scenerio
in master batch table i have various master batch like
200701-0001
200701-0002
200701-0003
Now each master batch can have multiple final mixed batch like
200701-0001-01
200701-0001-02
200701-0001-03
and this record is inserted in to fmix table.
so i have a form in which i have a dropdown menu in which all the master batch is listed,
i select 200701-0001 and that value is passed to next page where i will enter other fields data and insertion to my fmix_no will be done automatic like 200701-0001-01, 200701-0001-02 and so on,
how to achieve this
so in short each master batch will have more than one final mixed batch.
pls help, also if u have any online contact in yahoo or msn pls send me, i am so confused and badly struck deadline is just couple of hours away. my yahoo id is(E-Mail address blocked: See forum rules) you can PM me i am online right now.
I want To handel the error messages by myself in one part in my script. I know that in VB I can Use the statment - On error resume next And I also know that I can retrive the Error Number In VB with Err.Number.
How can I handel the errors by myself in ASP? I heard about the ASPErr Object, Is it the same thing like the err object in VB?
I have an .asp page
that correctly queries a table and returns data if a 'job number' and
week ending date exist and the user can update the information that is
there. What I need to do is, if a record does not exist the page
needs to create one and then refresh/requery so the user can edit the
data. Any suggestions on how to accomplish this?
How can I check if a table exists in an access database using (asp with
javascript)
Using ASP with VBScript is there a clever way to easily check if a value exists in an array without looping through it?
View Replies View Relatedi have a textbox for user to put there loginid...and one button login valiablity...where user can click to check this userid is available...till here everything is ine...suppose between this another user registerd with same userid..and now first user will put this user id than it will get non avaliblity of this id.so in such case what should i do?
View Replies View RelatedI have 2 tables: customers(id,FName,LName,MLMId) and Mlm(id, CustomerMlmID)
I have done a insert form for customers but first i want to check the form to see if MLMId is already exists from the second table.
I want to avoid duplicate files so how can I check to make sure the filename of the uploading file doesn't already exist? I want to do something like.
if UploadRequest.Item(AF_curKey).Item("FileName") <> some_file then
We have two tables EmpProfile and holidaysrequest tables.
EmpProfile has fields
EmpNo
Firstname
Lastname etc
HolidayRequests has fields
EmpNo
FromDate
ToDate
holiday requests table stores the dates employees have booked as holidays.
I want to write a query which will be used by ASP page to display everyone
who have not booked 29th - 31st Dec as days off.
I have built a page that lists all our databases, the
users connected to each database, and what application
they are using. Because these databases are moved, or
removed from time to time I need to check if the database
still exists before trying to query it. Otherwise I get
funny SID errors when it tries to process this command:-
Conn4.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=CD;" & _
"User Id=username;" & _
"Password=password"
Can this be done in ASP or should I be querying the error
collection or something?
Just wondering if someone could look at this and see where I may be going wrong. The basic concept is to use FileSystemObject to see if an image exists. If it does, display the image. If not, display image does not exists message.
<%
Set fs=Server.CreateObject("Scripting.FileSystemObject")
strFilename = ="e:path oimageprodPixscienceTN" &
(RecordSet1.Fields.Item("ID").Value) & ".jpg"
If (fs.FileExists(strFilename))=true Then %>
<%=(Recordset1.Fields.Item("ID").Value)%>
<%
Else
Response.Write("No Image Available")
End If
set fs=nothing
%>
I populate a recordset and dump it into an array. How can I check if a value exist in the array? I want to check if the c_Member_mgr has a particular value or not?
Dim rs2
set rs2 = Server.CreateObject("ADODB.Recordset")
rs2.open sub_Emp_Source, Conn
Dim aSubordinates
If not rs2.EOF then
aSubordinates = rs2.GetRows()
'Close Recordset to use the new array with the 2 columns data
rs2.Close()
set rs2 = Nothing
'Declare Constants for the above SQL columns for better readability
'Use these Constants instead of referring to the array numeric indexes
Const c_Member_Mgr = 0
Const c_Subordinate = 1
Const c_EmpID = 3
Const c_EmpName = 4
I'm building some dynamic image links based on if the image file exists. How can I check 'if files exists' using asp or javascript? I've messed around some with FileSystemObject but so far no success.
View Replies View RelatedI have a table in SQL2000 called EmployeeID and a column called UserName
I have a form which grabs the data inputted: Code:
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 Relatedis it possible to check a table exists before opening the record set? We have a sql query that requests information from a table depending on what information the user enters. So if the user enters information that requests a table that does not exist then I get the following error -:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'y2005m12'
therefore is there a way to check the table exists before running the query or opening the recordset, and therefore redirecting the user to a different pages informing them of the problem?
How can i check to see if an array (specifically a session variable, if it matters) exists or not?
View Replies View RelatedI'm wanting to do a simple controlled voting page. I too our webserver off anonymous and everyone who accesses the website is a domain authenticated user. I've already done some control structure pages based on Request.ServerVariables("AUTH_USER"), which works great. That's also how I would do this page, in my basic thinking.
My idea is to have an access database with two tables. One table will have the vote written to it and the other table will have the AUTH_USER written to it when the employee casts their vote.
I'm wondering how I would do a test against that table to see if their name has already been written to the table. So, if an employee votes already, when they go to vote again, their user logon would be tested against all entries in the table and if it exists, the vote would not be written and they would be redirected to another page that politely tells them they've already voted.
I want to check whether a particular table exists or not in a database as we check whether a particular record exists in the table using Count(*) function.I get the table name from the user and will have to check whether the entry that he has given is a valid one or not. how to do this?
View Replies View RelatedI have a left menu that is accessed and displayed via XMLHTTP (it resides on the same server). Some sections of the web site don't have a "menu.asp", so a "Page Not Found" page is returned, which doesn't look great in the menu column.. Is there a way to know if a page exists before using xml.responseText to pull it?
View Replies View RelatedI have a problem with asp encrypt. I always encouter this error message when i try to log in my system thru an IP address. The strange thing i that, onli my computer is experiencing this problem. I tried loggin in using another computer, with the same IP address.. and it's sucuessful. Izzit the problem wif my ASP encrypt or wad? The error i have is:
Persits.CryptoManager.1 (0x800A0001)
Object already exists.
how could I know if a specific sessionid still exists or not. If there is a method or anything that can tell me about the existence of a specific sessionid .
View Replies View Relatedhow can i check to see if a variable exists? or whether it has been set in asp?
View Replies View Relatedhow to check whther subfolders/files exists inside a main folder using a filesystem object.
View Replies View RelatedYou'd think this would be the most basic sql query in the world but noooooo!
I've tried this:
on error resume next
strsql = "SELECT * FROM " & session("TablePrefix") & CurrentTable
SET rs = conn.execute(strsql)
tableExists = 0
if (Err.number = 0) then
tableExists = 1
end if
But it doesn't return an error if the table doesn't exist. I'm searching on
the internet and hitting these long complicatred solutions involving the
database "shema". Surely there is a simple way of telling with one line of
sql if a table exists or not?
I'm currently workin on a project where by users have to register. I picked up some code from the internet but i get the following error: That username is already in use. Please choose another even though there is no data in my database yet. I'm using access 2000 as my database program. Code:
View Replies View RelatedI am working on a image gallery and am trying to show images from different websites. Before I display an image I need to know whether that image exists on the other server and only display it if it exists.
View Replies View Relatedhow to get many item in LIKE funtion?
Dim count integer
Dim part() as string
For i = o to i =count step 1
Sql = "SELECT TOP 5 T1.A,T1.B " & _
"FROM Table1 " & _
"WHERE T1.A LIKE '" & item[1]& "%' " & _
But the array [1] got error. How to get the array?Please advise me for the above problem.