Duplicate SQL Records Created ?
I am trying to do a simple INSERT into SQL. I've done it tons of times before with the same code, but this time is is placing duplicate entries in the table. Any ideas why this would be happening? Here is my ASP code doing the form processing:
<%
set conn=server.createobject("adodb.connection")
conn.Open "Driver={SQL Server}; Server=SERVERNAME; Database=DATABASENAME; UID=USER; PWD=PASSWORD"
set rs = Server.CreateObject("ADODB.RecordSet")
strTitle = Replace(request.Form("title"), "'", "'")
strContent = Replace(request.Form("txtContent"), "'", "'")
strSQL = "INSERT INTO [webPages] ([created], [section], [title], [content]) Values ('" & now() & "','" & request.Form("section") & "','" & strTitle & "','" & strContent & "')"
rs.Open strSQL, conn, 3
%>
View Replies
ADVERTISEMENT
My table in the database may contain duplicate records, which means except
the primary key (auto_increment) field is unique, all or almost of all the
fields are with the same content. How can I select them to display and
delete them?
View Replies
View Related
I'm connecting to an MS Access database using ASP. Within my database I have duplicate records (more specifically records with the same serial no.). When I search by the serial number only the first record is displayed. I would like to display all records containing the given serial no.
View Replies
View Related
how can i get duplicate records through a sql query i am using MS Access database.
View Replies
View Related
A table exists that is built like this:
CREATE TABLE tb_test (name varchar(50))
The table is full of records; many are duplicates.
What would be the correct syntax to show ONLY those records appearing more than once?
A. Please do not use Stored Procedures
B. Please do not use User Defined Functions
C. Please do not use Variables
D. Please do not use Temporary Tables
E. Please do not use Views
View Replies
View Related
i want to hide duplicate record fields in an asp form, i have access database, e.g, i have a field schoolname, and studentname, 1 school have many students, so i want to print or display schoolname only once.
View Replies
View Related
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 Related
I am looking to create a calendar. I am stuck on how duplicate records based in a date parameter. Example
A person is off between 12-01-04 to 12-09-04 . They submitted a form than contains the description. I want the record to duplicate 8 times because of the date paremeter.
View Replies
View Related
I am adding simple records to a fairly simple access database with the following code
rsEntry.Fields("Player1") = ShortName(Player1)
rsEntry.Fields("Player2") = ShortName(Player2)
'Write the updated recordset to the database
rsEntry.Update
rsEntry.Close
adoCon.Close
Set rsEntry = Nothing
Set adoCon = Nothing
How can I SIMPLY :-) prevent duplicate records from being added? I know I can set the index property on the fields but that mean handling the errors - not sure how to do this.
OR I could write the code to seach the DB before update - which may be the only way :-(
Is there a simple way?
View Replies
View Related
Using the below tage, i successfully add a new Record to my Videos table but the varibale i declare with the newly created rs ID is always blank? Code:
View Replies
View Related
I am facing a strange problem in my application. Its a ASP application. I have a drop down one page. When I select a value from the drop down, its an ASP call, after processing ,new session starts. This doesent happen for the first 3 or 4 times when i select the value from the drop down.
Also I noticed that when the new session is created , the old session is still alive.
Can You suggest me as to Y the Web Server tries to create the new session, when the existing session is still alive.
View Replies
View Related
It is possible to create an image of the format gif, jpg or png with VBScript? If yes can somebody tell me where I can find such references?
View Replies
View Related
After restart some time is everithing ok. After some hours - some days, problem start. Only in pool, where dll VB6 is used, aspx pages (asp ok) does not work.
Event:
Failed to execute request because the App-Domain could not be created.
Error: 0x8007000e Not enough storage is available to complete this operation.
Source: ASP.NET 2.0.50727.0
Event ID: 1088
OS: Windows 2003 Server SP1
HW: dual Xeon, 4GB RAM, Server is not Domain server. dll VB6 is used in pool where aspx pages does not work, in other pools aspx pages work.
View Replies
View Related
I have this form that creates a row in my access database. I then put in the action of the form another asp page with a questionmark and some stuff.
What stuff do I put there to help the other page recognize which row I'm talking about and be able to pull the correct information?
View Replies
View Related
Using preferably Asp or an Asp component, but maybe .NET, here is what I need to do:
A user enters a hex value (Or rgb if need be), which then colors a pixel high, n pixels wide gif and saves it to a folder in the sites directory.
View Replies
View Related
The session_onstart event will fire for every pull BECAUSE no SESSIONID cookie is ever created and the server has to assume that every HTTP REQUEST frame is a new session. The response object is actually just setting a header, of course.
Every redirect is sending a header to the browser equivalent to a "meta refresh" and that once again triggers the session_onstart.
View Replies
View Related
I am reading and setting a cookie using JavaScript in the BODY onload
and onunload events respectively. This works fine.
However when I use ASP to set the cookie under some condition where I
want to override the last value set in the onunload event, it has no
effect. The next onload still has the old value.
The following code simulates the problem I experience....
View Replies
View Related
I'm having a problem dynamically creating an UPDATE query that will write the string value of an existing record set field into a data base.To be more concrete, I can generate a string that looks like this:
UPDATE Person SET Person.name='objRS("oldname")'
but when I try to execute it, the literal objRS("oldname")gets written into the oldname field of the Person table, as opposed to the value 'Betty'. (In a separate write statement, I've already checked that objRS("oldname") prints 'Betty'.)
And if I change it to:
UPDATE Person SET Person.name=objRS("oldname")
I get an error saying there is an undefined function 'objRS' in expression. Can anyone help me? If I can get this to work I'll be done with this task.
View Replies
View Related
I run a website that reads our own databases and makes the data available to our users. However, recently someone has sent me a link to a php page that contains data they want me to display on our site. The php creates a csv formatted text string.
Example : I type in www.somewebsite.php and the page returns game1,gamedate,gametime,hometeam,visitor,,,, with real values of course being in these values. the ,,, are null fields that have no value as they expect our website to fill in this data for them from our users. how do I read this data with asp into a recordset, or a database?
View Replies
View Related
I have an asp.net application that generates dynamic images (charts). When I run the application in debug mode from visual studio, or refer to the url with localhost in the name, everything works fine. When I try to access the site with the full machine name (not using localhost), or from another machine, the dynamic images only appear as red x's.
I've searched the groups, but can't find anything that seams to relate. I am assuming this is some sort of security setting, which I have messed around with in IIS as
well.
View Replies
View Related
I'm using PerlScript in my ASP page and I have the following problem: Each time the page is refreshed a CSV file is created. I want this file to be available for download. The problem is I can't create the file in the "wwwrootsite" dir, so I can't link to it. I can however create anywhere else on the server.
View Replies
View Related
Is it possible to assign permissions on the fly as you are creating a directory structure on the web server?
I want to create a new folder for each new user of this system I built. Each folder will have the same permissions and will be used for uploading images. Should I just have write permissions on the parent folder and have the folder permissions inherited from the parent? Or is there a better way to do it?
View Replies
View Related
I'm struggling with this problem: in a website I developed, XML files are created by users of the site to describe. The creation is OK, the (new) file is present, but it can not be read by any website visitor.
How can the default permission become at least readable?
It's a ASP script running on W2K, using the FileSystemObject component.
View Replies
View Related
I have created a session, where a user logs in using his/her email address and password.
Howver I now want to display the users name once he/she is logged in. It should be easy,
but I cant quite get my head around it.
View Replies
View Related
I have some cookies created with javascript, I need to be able to delete them (by expiring them) or set their contents to nothing ("") using ASP. However, when I try to do this, it doesn't work. If I try to set their values to nothing by doing:
for each x in Request.Cookies
response.cookies(x)=""
next
It just creates a duplicate of each of the cookies with no content.
If I try to expire the cookies by doing the following:
for each x in Request.Cookies
response.cookies(x).Expires=date-1
next
It does nothing. They don't expire.
How can I get ASP to recognise and modify the actual cookies which are there?
View Replies
View Related
I have files in a folder that I am using the FileSystemObject to read. I can read the files and display links to them no problem, what I want to do is to sort them by date created.What is the best way to go about this?
View Replies
View Related
Just installed VS2003 and tried a hello world app. Getting 404 error even
when I explictly specify the start page in the url.
In IIS Mgr (v 5.1), App has .aspx mapped to
C:WINDOWSMicrosoft.NETFrameworkv1.1.4322aspne t_isapi.dll.
The file in question IS in the virtual directory and this is the inetmgr log
file entry that occurs when my browser requests the page: 19:42:27 127.0.0.1
GET /UP1/WebForm1.aspx 404 Code:
View Replies
View Related
I want to delete all the cookies which are created for the application.If i know the names of a cookies i can delete the cookies or i can set the expire properties.
View Replies
View Related
When I use a host file entry to point to the host header of the site
that I have created on a Win2k server running IIS5, a cookie is not
created to hold the session id. The result is that Session_OnStart is
run every time a page is requested.
If I set up a DNS entry on the DNS server it all works fine.
I never noticed this problem before we put in Active Directory so it
may have something to do with that.
I have set "allow per session cookies" to promt(under Custom Secrity
settings in IE) to see if this is being attempted and it is not. So
the browser is not even trying to create the session cookie when using
the host file.
View Replies
View Related
I am having trouble loading the result of a VBscript split function into an array. The script is supposed to take the user's login name (the form for this is name separated by underscores such as john_foo or lisa_wilson), split it at the underscores, and load first, middle and last name into an array. The problem I keep getting though, is that I am getting a type mismatch error. Here is the code:
<%dim LogName, NameArray(), FirstName, LastName, MiddleName, LastPage
'Get NT authorized login info
LogName = request.servervariables("logon_user")
NameArray = Split(LogName, "_")
for x = 0 to UBound(NameArray)
response.write NameArray(x) & "<br>"
next
%>
The FirstName, MiddleName, LastName vars are supposed to take the array values later.
View Replies
View Related
I created controls dynamically.I want to capture the information from those
controls. Code:
View Replies
View Related
When i create a folder through file system object and then check the properties of that folder, read only attribute is checked. At this time after creating the folder i need to put files in the folder and i get error due to this reason. Is it possible to make sure that read only attribute is not checked.
Also at the company we use active file component to Upload the files. Active file provides the functionality of file system object too. I have created the folder through this and the result is the same.
View Replies
View Related
I'm using ASP 3.0,IIS and Java script.I have created some text boxes Dynamically using java script.So the text boxes has got the same name. This is the code i'm using for that..
aTable1=document.all('myTableTBody1')
aRow1 = aTable1.insertRow(aTable1.rows.length);
aRow =aRow1
aCell = aRow.insertCell(0);
aCell.align = "Left";
aCell.width = "5%";
aCell.innerHTML = "<input type='text' name='Course' size='20'>";
Problem is that when i'm doing client side validation using javascript its not taking values..Here 2 or 3 or 4 text boxes with the course will be created when i use
this code:
if (document.Qualificationdetails.Course.value == "") {
window.alert ("Enter Course !");
document.Qualificationdetails.Course.focus();
return false;
}
it does not give any validation...
View Replies
View Related