What I want to know is how do you check if a record exists in a MSSQL database. When a user visits a page in my ASP app it picks up thier username and uses it later on in the app.
What I want to know is how do I say in asp and sql , do I have a record in my database for user "john smith"? Then I can shoose my next action according to weather or not the user exists. Make sense? Code:
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?
I'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 have a database in which I have to on a daily basis enter the information for that day. I would like to update this on a bi-hourly basis to prevent any possible data loss.
Using INSERT INTO, I create a new table line. Using UPDATE, I get an error on the inital creation of the table line.I am really unsure how to check to see if that line exists or if there is an easier way around this.
I've got a form that adds a record to a database. What I want to do is on submit, look at the records in the database to make sure no value in a particular column matches what the individual is trying to submit.
More simply, Form A has a field called "collection" which inserts into the database column named "collection" I want to make sure that the value in the collection field hasn't been used.
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 am trying to creating a function to find a record that was entered in a database. I have created the add button with no problem and it works. The links are:
Text file
ASP file
When I placed the script in the code (lines #524 - #547), I now get an error message looking for an "end" statement. Before this everything worked fine. If I have and "else" statement after closing the form and and "else" statement after opening the recordset, I don't understand where I need the "end statement."
I have a page where a user can submit a record for a new "applicant". After the user clicks Submit, I would like to send the user to a new page containg the "Applicant Number" which the user will need.
The applicant number is simply the autonumbering of the record in the table which is in a SQL Server db. How do I capture the record number(primary key) of the newly entered record in the table and send it to my new page?
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
I have imported a list of links to MSSQL database with enterprise manager. I use ASP to show the list of links and it's description. Originally I had 8600 links in the database and I have imported 700 new one.
I have checked in table and all the links exist and the table is indexed on field linkID. My asp script has worked before and there is no problem with it.
I can still show all the links including the new links and it's descriptions but if I click on an old link, it goes to that site while with new imports, it just opens another example of my site (404 page set to open my index page).
The link is correct since if I copy it from screen and paste in browser, it opens the page correctly.I have removed the index from table and made it again but no difference. There is also an edit function in my script, if I click on it, I will get a message that filed linkID does not exits but it clearly exists in the table and the rest of script is using it.
If I creat a ASP page, what do I need or how do I connect to a MSSQL database? Is it possible to connect to MySQL with an ASP page, or is it better to stick with MSSQL when creating an ASP page?
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
Does anyone try before using ASP to execute JOB in MSSQL?
View Replies View RelatedI was wondering if anyone could give me some pointers as to using ASP (Javascript, not VB) to get XML out of SQL.
I have my storedProc with the FOR XML AUTO on the end, and that is returning a recordset with XML fine in query analyzer.
I am lost as to how to output this as XML from an ASP page so I can transform it with XSL.
My transform would be something like: Code:
Looking for suggestions on any stable asp/MS SQL server content management systems in the market place. Any suggestions, or even places where I can look? I have quickly seen Rainbow and would like any comments from users of this CMS.
View Replies View RelatedI am currently learning ASP but have a small PHP background,
With PHP I used PHPMYADMIN to work with MYSQL
Is there a web based Alternative for
ASP and MSSQL that provides similair functionality?
I have a query to one table but one of the values in the table is referencing a record from another table... here is the sql Code:
strSql = "SELECT streetdate, barcode, itemname, descrip, vendor, sku, catlog, config, retail_cost, cost FROM blah WHERE (STREETDATE >='"& GSTARTDATE &"') AND (STREETDATE <='"& GENDDATE &"') ORDER BY STREETDATE, CATLOG DESC"
now I have 2 things going on here...
1. vendor is just a number... there is a tblvendor that matches the number with a name (that i need.. i coudl nest another db query but figured that would be more resource intensive as this returns 1000s of records)
2. itemname is also a number that references another tblItem the sam way, I woul dlike to sort alphabetical off this somehow (is it even possable)
Can't seem to find anything relating so forgive me if i've missed it.
I'm after a way to open either a csv or xml file, then cycle through each line to see if it's in mssql, if it is update it... otherwise add it and then if it's in mssql and not the csv, remove it.Is it possable?
Still learning and haven't dug into opening files, let alone this so any help would be grateful... oh and the fields are exactly the same in both
Anyone know of a free advanced mssql hit counter?
View Replies View RelatedIn our office we use RMS (Residential Management System) and they use an MSSQL database to store all the data. we can access this database using access and have made several...several queries to pull out info, save it to another access database, then upload it to the web and pull data from it.
the server that houses the MSSQL database is online and i was wondering if it is possible to connect to it and pull out information. we wouldnt want to change anything, just view.
so to connect to it, what all do i need to do?
I'm just deciding whether to use Access or MS-SQL for a web-application
I'm predicting that my application will grow large enough to warrant use of MS-SQL, but I'm wondering how extensive the changes to my code that would make
...Specificially in ASP.Net, if I use ADO.Net, would I just need to modify my connection string or would it involve more extensive modifications?
I am new to programming and I managed to store images in MSSQL.
The problem I have is that when I retrieve the image from the database
and display it in my browser it opens a new window. I would like to use
the image control, but it requires a url. Is there anyway of viewing that image
in the image control or keeping it in the same page where my information is
but displaying it where and when I want it
I want an answer by tomorrow with examples and reference URLS if we can do this.There is a program written in ASP and the databse is MSSQL (Microsoft) hosted in Windows platform.
But they want this databse and ASP Program host on a UNLIX/LINUX server and use the same ASP program. Can thy do it/ and how?
I had used ASP about a year ago, I had connected to a *.MDB database but not MSSQL,can someone please throw me the just of it
View Replies View RelatedI am using a Windows 2000 Server and when i tried creating a simple asp application this error always appear everytime I access the database. Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'MYSERVERIUSR_MYSERVER'.
/o/faculty_evaluation/add_dean_db.asp, line 22
what kind of error is this?
is there something wrong with my connection string -> conn.Open "Provider=sqloledb;Data Source=MYSERVER;Initial Catalog=dog_evaluation;Integrated Security=SSPI;"
any one have the connection string and included query on how to connect to the mssql server?
View Replies View RelatedIf I create an ASP page, what do I need or how do I connect to a MSSQL database. And, is it possible to connect to a MySQL with ASP, or is it better to use MSSQL when developing a ASP page?
View Replies View RelatedI am planning to convert an ASP/MS SQL based site into ASP/MySQL to save on monthly recurring fees. MSSQL costs additional $40 a month while MySQL is free. Are there any major technical issues?
View Replies View RelatedIf you have a large traffic site, say over 30 current users accessing the database at once, can Access handle this. I know MSSQL can. Is there any other databases that can be used with asp other than Access and MSSQL and what would there benifits be?
View Replies View RelatedI'm writing a script to show a bithday list. I select the data from a MSSQL db. I want to only show the next seven days's birthdays in the result. Something's wrong with my script below and would appreciate it if somebody could just have a quick look and let me know. Everything works well, but at the end of the month the order by doesn't work 100%
Below is the code:
<%
Function formStr(s)
if not isNull(s) then
formStr = UCase(Left(s,1)) & lCase(right(s, len(s)-1))
else
formStr = ""
end if
End Function
i have a website on fast hosts and i have a mssql data base, i have set up the data base using enterprise manager. and i am now trying connect to it it via asp page but i am getting this message. is this wrong?
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login ' lstudents'. Login fails.
/default.asp, line 14
here is the line of my code that connects to the database.
<%conn.open "DRIVER={SQL Server};SERVER=213.171.218.235;UID=xxxxxx;PWD=xxxx xx;DATABASE= mytable"%>
How can I check if a table exists in an access database using (asp with
javascript)