im trying to add the delete record behaviour with dreamweaver. iv set up all the text fields and the recordsets but when the behaviour is generated the error "the original recordset in the script was not found". i have the add record server behaviour working, but this is not .
View RepliesI'm new to ASP so I'm using DWMX as a crutch. It created the db connection and recordset code for me and all I want to do is have the page update the db with the result of a variable.
In plain English, I'm trying to update a field called Score in the table quizOne with the results of the variable score where the username field matches the session variable MM_Username. The recordset is called update_score.
Based on other tutorials and forums, I tried this: ....
I need to alter a dremweaver Update Record function but am a bit lost with it. I basically need to take the values from 3 drop downs that let you selct the date (day, month year). I've written a variavble that adds these together to make a date:
JJ_theDate = Request.Form(selectDay) & "-" & Request.Form(selectMonth) & "-" & Request.Form(selectYear)
but have no idea how/where to slot this in with Dreamwevers code (below) that does the SQL update.. Code:
I been working on this code for a long time, code doesn't work and It also doesn't show any error. All I am trying to do is delete record. I click on id number from first page that brings me to this page. Code:
View Replies View RelatedI am trying to delete a chosen record out of my Access database using the ID field as the parameter. I can get the script to output the record so I know it has the record, it just won't delete! Code:
View Replies View RelatedI'm simply trying to check if the categoryid is currently being used by any catalogue/product items.
Ok, I've created a mini site content management system and I'm stuck on this function that will ensure data integrity...
I'm trying to check if the categoryid I'm trying to delete has any related 'catalogue' items (products); and if so display a message 'Sorry, there are items currently listed under this category. Move the items before trying to delete'. Basically disallow the delete function if any catalogue items share the categoryid. That's it! Simple... right???
Code:
I have news type thing on my website that displays news items that are entered using a simple html form. they go to a database (real simple so far)I also have an edit form where it loads up the entries from the database onto html forms and you can edit them and then click submit and it applies the changes to the sql database.
simple as well.one thing I can't figure out is how to add a delete button or a delete checkmark so that I can go and delete the entry out of the Database?
I have a microsoft sql database and some tables. One table of them has some dealer's requests for giving to them a mastercode for viewing some special prices. The dealer's informations appears to an asp page in a table.
i want to put a button or an link (query string) to delete separately each record. (the primary key is "clientID"). How i can do this. Which is the command?
In our database, we have a table which contains numbered items. Here is what I'm talking about: Code:
VBKey ChargeCount
12 1
12 2
12 3
12 4
19 1
19 2
When we need to delete a particular Charge (From the ChargeCount column), how can I get the remaining charges to be renumbered. For example, if I delete VBKey=12 and ChargeCount=2, how can I make ChargeCounts 3 & 4 turn into 2 & 3? I'm a little lost at making a query for it?
I'm trying to delete a record by ID. When the user clicks on the record they want deleted from website form it should delete this one record only. But I'm getting this error. Code:
View Replies View Relatedhow do you delete data using asp, let's say i have a data listing page and by every record i want to have a delete button ?
View Replies View RelatedI get this weird error when I try to delete a record...
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'Cal_EventID ='.
/calendar.asp, line 1596
Here is this code on line 1596.
Code:
SQL = "SELECT * FROM Cal_Events WHERE Cal_EventID = " & SafeSQL(request.querystring("eventid"))
Set RS=dbc.execute(SQL)
I have written an events diary for a client .. and they wish to have a system of multiple deletes so they simply use a check box to select the items to delete and then hit a button to remove the selected records form the database. as all iget is scripting errors. Is there a simple way to do this?
Someone advised me to use an IN statement to Delete multiple records, but all I get is :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ID In ()'.
I have followed several different tutorials but I get the same outcome! It doesn't seem to like the IN statement.... any ideas anyone ???
i have found various example scripts to add/edit from database, but how can i show all the db records by id on a page, then have a form with a box to choose which record to edit/delete by id, and then when chosen, it shows the info for the record in a form, which then can be just edited and updated?
I want it to be just like as if you had just typed the details into the form itself before you registered.
I'm trying to build a web page that will automatically delete records (in Access 2k) after a certain amount of time. I need to delete records that are older than a month of the current date.
I've searched all over the internet trying to find examples of how to do this and the few that I've found don't seem to work for me. Does anyone have an example that works? Either using an sql query or programmatically. I'm using Classic ASP (VBScript).
Im trying to setup a delete record thing and it keeps telling me before using this server behavior please create a record set. However I already have a recordset on that page named rsDelete.
View Replies View RelatedI have a search page ( below is some of the code). I am currently displaying records from my Access database. At the end of each row, I am printing out a delete.gif. On click of this image I would like to Delete the printed record. How do I do this? Can you point me in the right direction? Code:
View Replies View RelatedI just need to know the DateDiff function for what I need to do...
I will store the date of the database record in a variable called 'sDate' what now? (Also, the format is xx/xx/xx 2:4:56 PM/AM)
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:
using dreamweaver mx,i created a 'jump menu' trying to do this below:
Code:
<option value="Settings/CT2004S1/setCT2004S1.asp?paper=Common Test 2004 Semester 1" selected>Common
but seem not possible..
<%response.write Request.QueryString("Paper")%>
Dreamweaver MX has a behavior called Restrict Access To Page. It is not working for me. I have Access 2000 db set up and working. The registration and login pages work based on the database info. It is only this behavior I can not get to work. My db has a field AccessLevel. There I made sure I had admin entered to match to the Behavior condition. I still do not get access to the page even though the admin is the AccessLevel condition.
Here is the code.....
I keep my church's website updated. Recently they got someone to do a new design. This guy used asp for all the pages and I know nothing about it. When I try to make updates I try to view the page with DreamweaverMX 2004, but it all comes out funky looking.
The footer is at the top of the page, the text is all on one side. Graphics are just wherever. Believe it or not I can update this, but I frequently have to do pages from scratch and I would like to know what it will look like before I download to the server. Is there some setting I can change on Dreamweaver to make things look right.
Our designer doesn't have a clue. He just says to learn to write code. I can learn the code if I have to but we have other volunteers who aren't as computer savvy.
I'm just about to embark on building a custom cms with Dreamweaver MX with ASP. I've done something on a very mico level, but i'm gonna go bigger this time.
Something along the lines of Interactive Tools Page Publisher.
Can someone recomend some invaluable (and free) Dreaweaver extensions that can help in this process. Also, if there are any good DWMX tutorials and open source stuff that can help in this process.
I'm using the out of the box Dreamweaver login script (I'm a super noob developer) and I'm interfacing with a database that uses MD5 to protect passwords. I need help modifying the DW code to work with this. Code:
View Replies View RelatedI've tried (during a trial period) Dreamweaver quite extensively for HTML coding. I thought it did a good job of that. I'm just dipping my toes into ASP, and I was wondering if people found it as good for ASP programming as they did for HTML.
I'm seriously thinking about purchasing either Dreamweaver or, may be Studio.
I see that Dreamweaver MX has a pre-written ASP login script that you can just drop in, as well as a drop-in for every page to ensure users are logged in before they can view the page.
Can any security-types out there tell me if this is any good? We're setting up one site where the database is above root level, so I'm hoping that the DW system will provide adequate security (since its SOOO easy to use). Will it?
Im using dream weaver to connect to my database. I hav e made my connection successfully,
added my recordset succesfully....however when i insert my dynamic text.....
I get this: Code:
Can someone tell me , how to apply jscript in dreamweaver, as well as the example, because I am trying to run jscript script with an include file ....
View Replies View RelatedI've been doing ASP by hand-coding in either Homesite or Interdev for years. I have been using Dreamwever for static sites that I make on the side. I recently was asked to make a form which will store info in an Access database, and thought it would be a good chance to learn how to use Dreamweaver MX's ASP capabilities.
Haven't tried it yet, but reading up on it, it seems that it forces you to use Session variables. I'm not a big fan of session variables, and want to avoid them. Anyone here use DW MX for ASP?
I know that this is not the most appropriate forum for this question, but after the excellent advice i have recieved from some members about various things I figured I would wrack your brains. The situation is this: The webserver in question is settled behind a firewall, and you can only get ftp access if your ip address is on a trusted list. A colleague of mine wants to access it from home but due to the fact that he has a dynamic ip address he is unable to be added to the trusted list.
I assumed that his access would be denied, and sure enough when i configured dreamweaver for the site it did indeed fail to connect. So far this makes sense, but then I discovered that if, when on the website in IE, if he clicks the edit with frontpage button frontpage will open and give him access to the site once he has logged in with the correct username/pass. He really needs to be able to access the site via dreamweaver so im wondering if anyone can explain how FrontPage is able to get access and if this information can be used to get dreamweaver connecting.
i have a site where i am showing staff from an office using a repeater in dreamweaver (link : http://www.remaxfinance.com.au/managers.aspx).
i want to put a button that says more info under each staff, and i guess i need to make a page names managerprofile.aspx, but how do i add that link from the managers.aspx page to the managerprofile.aspx page and have the ?&id=something. how do i make this work?
I am trying to create a form which emails the user with details of the
form.
My problem is that when i hover over the sumit button, it shows up as
test.asp and i want it to go to a specific email address.
I did have the action = test.asp but i then installed the FP extensions
and now it holds that value for some reason?! Code:
Once again I am having problems with the code DWMX2004 has generated. I'm getting an error message that says "Illegal assignment: 'Item'". Code:
View Replies View Related