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 RepliesMy 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?
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
%>
how can i get duplicate records through a sql query i am using MS Access database.
View Replies View RelatedA 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
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 RelatedI 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 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.
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?
I am trying to create a popup page to print little cards to Avery labels. I can get the page to work out but it always prints the margins to far over so it doesn't fit in the cells. I was wondering if any one new any resources to give details on how to accomplish this or of another method?I have also tried creating a dynamic word doc but then the user could change the text values which wouldn't work.
View Replies View RelatedI have a page with multiple SSI to content that is managed by other people in the organization. However, occassionally, one of the content managers accidently deletes a file or messes it up, which throws an .ASP error for the whole page. This is not good. I need to display the page, even if some of the include links are broken.
I tried using:
Code:
<%
On Error resume Next
%>
I need to let one person view certain things without having this perons
login. This person is logged in to the microsoft network. How do I get
that info into a variable?
if i have a recordset which contains a variable call remarks(which can be of any value)
how to i store this in an array? wat is the synatx?
array=rs1.Fields("REMARKS").value ???????
the need it cos i need to count the specific number of character inside this REMARKS. meaning say i output char 1 to 100 at box 1... and char 101 to 200 at box 2.
i'm about to built a budget DB driven site for someone. access is the cheapest option for me, as my host charges for mysql, plus i aint used it before! [:I]
they anticipate around 250 visitors per day. would access on a dsn-less jet connection hold up? how many consecutive users would it handle before it fell over.. ?
I've tried inserting this code, but it doen't work. I guess it must be something to do with the byVal keyword used in the constructor for the function?
Code:
'Handle a Null date
If (strDate = "" ) Or (Len(strDate) < 1) Or (strDate = Null) Then
fncFmtDate = "N/A"
Exit Function
End If
I created a web site for a local government office to handle their procurement. When the city modifies a solicitation, all of the respondants need to be notified. Unfortunately, the city wants the email sent to each respondant to be individualized, so I can't just CC or BCC it to several hundred email addresses.
After about 200 emails, the server usually times out. The city is hosting with Verio and Verio won't change the timeout values since it's "virtually hosted". Is there a way to spawn a background task to send the emails? If not, what's the best method for batch send?
How do i handle a subtraction between 2 entries in a table? they each belong to 2 tables. my code is below. I wish to subtract ordereditems_quantity from product_stock but i have no idea how to do it in asp. pls advise.
sqlString="SELECT * FROM products, ordereditems "
sqlString = sqlString & "WHERE product_id=ordereditems_productID"
RS.OPEN sqlString
product_stock = RS( "product_stock" )
ordereditems_quantity = RS( "ordereditems_quantity" )
I know a few ways to handle an apostrophe, but am at a loss for which i should use for this. The ways I know how to deal with it are.
alias = Replace(Request.form("alias"), "'", "''")
alias = Replace(Request.form("alias"), "'", " & #39; ")
The name of the field is self explanitory. When the admin searches for a person using the "'" , " ' ' " method they find the user. But when ever we display that info anyware it has the O''conner setup. Code:
How do i handle a subtraction between 2 entries in a table? they each belong to 2 tables. my code is below. I wish to subtract ordereditems_quantity from product_stock but i have no idea how to do it in asp.
sqlString="SELECT * FROM products, ordereditems "
sqlString = sqlString & "WHERE product_id=ordereditems_productID"
RS.OPEN sqlString
product_stock = RS( "product_stock" )
ordereditems_quantity = RS( "ordereditems_quantity" )
some of web search place my url with a problems:
like this:
http://www.mywebsite.com/page1.asp&&DI=293
I've integrated a secure certificate into my e-commerce site. However, when I forward people to the account log-in area (https) all of the relative links on the page obviously then point to http://www.mydomain/homepage for example.
How do I do what Dabs do, and redirect these links back to non-secure pages, without hard-coding all links as full URLs?
I've got a form that allows someone to upload a file. I need to know how I can grab the filename from the uploaded file information so that I can store it in a database. I also need to be able to move the uploaded file to a specific directory.
I'm new to both ASP & VBScript but I have both of their "In a Nutshell" O'Reilly manuals. There's no mention of file uploads in the ASP book and I'm just not sure if the info in the VBScript book is what I need either.
Do I need to create a File object? If so, how can I use GetFile to retrieve the downloaded file? Do I access it via Request.Form("filename")? That should be the actual file, right? But how do I get the actual file name from that?
What is the best way to handle inserting double and single quotes into a database via input from a form?
It's not a good option to remove them, since I need the text to contain punctuation sometimes. Likewise if I replace them with special characters (e.g.
Code:
& # 34 ; (without the spaces)
) it buggers up any HTML formatting I have in the textbox.
Is the best way to handle this to replace with HTML special characters then replace them back again in the database output?
I need to let one person view certain things without having this perons login. This person is logged in to the microsoft network. How do I get that info into a variable?
View Replies View Relatedhow to handle more than one submit button's request in an asp page. ie........
multiple web pages are leading to a single asp
page atlast. i want to distinguish between the web pages that are posting.
I inherited an ASP app at my new job. One of our potential customer would like to purchase it. He asked me if I know how much traffic can our ASP app handle. He also asked me if I can give him the rest "tech specs" about the web application.
I told him the app uses MS ASP technology and needs a MS SQL Server DB to store the data. But, how can I figure out how much traffic an ASP app can handle? Also, what does he mean by "tech specs"(other than what I already told him)?
Through javascript i am forming a dynamic sql based on some selection criteria entered by the user. If i am trying to have an alias with '&', then on executing this through an ADODB object , the statement fails and i get an error as "from keyword not found"
For ex: If i have a SQL as
select emp_name as "Emp&Mgr" from emp;
on executing this i get the above mentioned error.
But SQL's with other special characters do work.
For ex: select emp_name as "Emp,Mgr" from emp;
select emp_name as "Emp/Mgr" from emp;
select emp_name as "Emp*Mgr" from emp;
How do i solve this problem.
i have a view.asp . in which i am using select statement such as
"select * from table where id=" & id
its give error message that either bof or eof is not true when the id is not available.
suppose there are records from 1 to 100 id no . if i enter 111 then it gives error. how to handle invalid id no.
Can PHP Be setup to Handle sessions via a database without much intervention? so that like you coul store all the session data in the database. I have heard there is some sort of flag to enable automatic URL session generation
1] Can this be done at a client level and not a site administrator level?
2] Is it possible with this mechanism to do it to a DB without having to write special code?
3] If you do have to write special code can you still get it to insert the session URL details in the urls automatically?
hwo to use ASP to handle chinese characters output? I have try two ways.store the string in a text file(unicode file) . store the string in an access database
The first method got an error:
Active Server Pages error 'ASP 0239'
Cannot process file
UNICODE ASP files are not supported.
The second method output "???" on the browser.
Can ASP retrieve UTF-8 encoded data in query string properly, when
used with IIS 5.0 on Windows 2000 Pro/Server?
With some trial and error, it seems that adding the directive
@CodePage = 65001 to an ASP page makes the ASP page decode UTF-8 data
in query string properly. Without the directive,
Request.QueryString(var) returns garbled data. With the directive,
Request.QueryString(var) decodes UTF-8 encoded data properly. (I tried
passing it to database with ADO; and VBScript function Len() also
returned the correct string length. I passed UTF-8 encoded Chinese
characters during my test.)
My search on the Web and newgroups, however, returned mostly results
that say ASP does not support UTF-8 encoded data in query string.
One of the search results is
http://www.microsoft.com/technet/pr...y/interasp.mspx.
It was written in March 2000. Could things have changed since then?
Can anyone share their views and experience on this matter? Is the
@CodePage directive all that's needed to handle UTF-8 encoded data in
QueryString?
I have an ASP page calling a stored procedure. I have set the connection and command timeouts and I have error checking so I can trap a timeout from the stored proc (as detailed here)
[Link...]
This works if the stored proc just contains a "WAITFOR DELAY", but doesn't seem to throw an error when the stored proc contains long-running sql. Anyone have any ideas?
Search results on my site started to show a large number of page
links. I never had to deal with it before but it is time now. I am
trying to come up with a good logic / idea how to display a large
number of page links without showing all of them at once.
For example, if user is searching for "pets" and gets 50 pages back, I
want to show 10-20 page links and hide the rest. Also, the closer user
gets to the last visible pages, the more hidden page links become
visible. Something like Google does...
If somebody worked with it before, could you share with ideas, or
suggestions, or good examples to look at? Is there a standard way to
implement this, perhaps?