so I've had the file upload feature working on the website now for sometimes and feed file info into a database for use elsewhere. I can edit/update/delete/etc...
whatever on the database end with no trouble, but how do I delete an uploaded file itself using asp? Is there a way?
i have a recordset that displayed all the infos about a record and a delete herf or button i want whenever i wanna delete a record a dialog box to appear with YES/NO/CANCEL button.
yes to confirm delete no to disagree and return to the previous page Cancel to cancel the action and remain in the same page !!
Imagine I have a database table with three columns (userID, urlName, urlAddress). Imagine the values in these columns are "aa, bb, cc". Now imagine I have some information like this sotred in the table:
userID urlName urlAddress ------------------------------------------- aa bb cc aa bb cc aa bb cc aa bb cc aa bb cc xx bb cc zz bb cc
Now imagine that I wanted to delete urlName=bb where userID=aa....but not have it delete all 5 records with the same info in them?
I created connection to the Microsoft Access DB using DSN from my ASP page.
<% Set vpconn = Server.CreateObject("ADODB.Connection") vpconn.ConnectionString = "File Name=c:inetpubwwwrootDBDNAME.dsn" vpconn.Open ' Close connection immediately after opening for testing vpconn.Close Set vpconn=Nothing %>
The Microsoft Access, for every database opened for shared use, creates an .ldb file to prevent users from writing data to pages that other users have locked. Whenever the last user closes a shared database, the .ldb file should be deleted.
It is working; the .ldb file is deleted immediately after closing connection but not if you open/close this connection from your ASP page.
What I found, the .ldb file is deleted with about 70 seconds delays after closing connection from an ASP page.
The problem concerns 2 tables, cart_products and cart_shoppingcart.
Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.
cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).
Now, what I want to do is this:
For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).
I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".
I'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.
I have an Access database with two fields that I would like to group by. The two fields are location and department. Field names are "Location" and "DeptName".
I have the code correct for grouping by location. That code looks like this: Code:
when i update a database from an asp page i get the error:
**filename** Source: Microsoft JET Database Engine Error: 80004005 Description: Record is too large. Line: 435 Column: 0 Code: Connection.Execute(sSQL)
is there a limit to the maximum updatable fields that anyone knows? the fields are text but theres 62 to update, it seems to top out at about 18 fields?
I'm making a leaderbord in golf and i only want the top 3 leaders out from the database. My code is as follows.
<% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "Driver={MySql}; Server=myserver; uid=username; pwd=password; database=database; option=3; port=3306;" Set rs = Conn.Execute ("Select TOP 3 FROM leaderboard ORDER BY points desc") WHILE NOT rs.eof %>
I'm getting this error message. You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '3 FROM rangliste ORDER BY Oakies desc' at line 1
I have a javascript function that sends table data to excel. One of the tables is 238 rows, not big but it doesn't send, i know the code works because i tested other scenerio's and they all went to excel. Does anybody know how many records you can bring to excel?
How can I get the last two records of a RS,I use this code to get the LAST record,but I want the LAST TWO records.
Code:
Private Sub GetLatestRecord() Dim SQL SQL = "SELECT * FROM tblHouses WHERE DateAdded = (SELECT Max(DateAdded) FROM tblHouses)" SET objRS = objConn.Execute(SQL) End Sub
Im having some trouble displaying top 10 records.here is my sql in my asp
strSQL1 = "SELECT Top 10 * FROM tblFlashinfo ORDER BY Vote_Score DESC "
it orders them correctly but displays all of them not just the top 10 . How can i fix this?also i have another question, i need to make sure a user can only submit a form with the same hidden field value once in a 24 hour period. Is this possible and if so how may i do this? both problems can be seen in this little system im making.
id will be autonumber and gift_id will be alpha numeric field . i want to generate this table with a query. i want to have the alpha numeric field to be 12 digits long. so i want to have like 50,000 records for it. how can i do it.
I'm writing a news script in asp with an access database. I want to show the last/latest 3 records, and have all the rest of them ordered into pages of 3 in an archive. How can I do this please? 'cause I know how to show the first 3 records but I can't work out how to show only the last 3.
i have a working members registration script where members register and it emails confirmation of their registration details to the email address they enter. what i would then like it to do is add them to the users database. I have the code but it chucks up this error when it tries to add the user:
Microsoft OLE DB Provider for ODBC Drivers- Error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Course_Info and Students. Course_Info holds all the information for each course that a student can sign up for. The Students table holds all of the student’s information. The field that ties the two tables together is Course_Name.
I have an admin page that I would like to display the total number of students enrolled for each class. How can I count the records in the Students table, and then display the total number of students that are enrolled in each individual classes?
Does anyone know if it's possible to use the records stored in an Access 2002 database to log users into an ASP.net page? I'm trying to code it in vb.net but im not sure how it could be done. Basically I think I need 2 text boxes on the ASP page where the user can enter their name and password.
I then somehow need to retrieve the name and password from fields in the database (using ADO.net i think) and compare them with those entered by the user. If they match then I want to load another page, and if not then I want to display a message saying login details are incorrect.
Any help on this subject would be much appreciated- the fields i have at the moment are called 'User' and 'Password' in a table called PERSON.
Is there another way to count the records of an access database that have a specific field other than using a SELECT statement and a recordset to loop through the records?
i am using ASP.I connected my page with access database.Now i want to featch records from the database one by one ,by a button,whenever a client click that button next record should be displayed on the same page.Is there any way to do this.
I have this search and results system on one page.... I'd like it where the results that come up from the search are editable and can be updated. I can't seem to figure out a working way to update more than one field at a time.anyone have a good piece of code for multiple edits
Still working on my soccer database, I have a list of 100s of teams and want to give users various ways of accessing the information. One of those methods would be via a drop down box which would have
A-F G-M N-T U-Z
If a user selects a-f how could I write my sql statement so that it pulls out the relevant teams, in alphabetical order, that begin with the letters a-f?