I have made several Access-based CMSs but now I am using SQL Server. I can read the records but my first attempts at writing are resulting in new records (with new ID) but all the fields are null.
I am posting the data from a form to the same page and an if /then statement catches the flag in the URL and runs the update script below. All the field names are correct. Code:
I have just created a register page for my site. I have had one running for years now, but I want to upgrade so it works a bit better.
Using the code below, the record that is entered into the database is corrupt. If i try and view the page with my admin page (works with records created with my old registration system), i get a 500 error, and if i view the database in access, the rows entered by thius code all show as hash symbols... any ideas? Code:
I'm extracting some information from a table and some fields maybe be holding null value. i tried doing something like this
if rs(VerbalWarning) = NULL then
rs(VerbalWarning) = "NULL"
else
end if
it dosent work. How do i display Null values in my output to make it more meaning full.
What to only show the Null fields on an ASP Update form. eg.
<% If "Recordset1.Fields.Item("B15-1").Value" = IsNull then %><input type="text" name="B151" value="<%=(Recordset1.Fields.Item("B15-1").Value)%>" size="32"> ...etc
get what i mean? Needs to be per field - as the exact fields will differ from record to record Any ideas?
I currently have a table which has empty values in it. I would like the asp page to right 'No Record' whenit comes across it being blank. If it isn't blank i'd like it to write what is in that field within the SQL Database Table.
I have entered the code below but nothing is being written on the page. Its as though its just ignopring the first part of the If statement and writing nothing as that is what it finds in the db. <% If IsNull(objRS("TrackDate1")) then Response.write("No Record") else Response.Write(TrackDate1) end if %>.
I would like to update a field with the value of a "empty check box". The problem that my numeral field (kom1) in the db will be emty, instead of 0.
I need the value 0 becaus it's used by a SUM in an query.
I would like to update a NULL value in "LEDef _Champ1" of the table "dbo.LEDef "
Here is the asp code :
objUpdateModule.CommandText = "UPDATE dbo.LEDef SET LEDef _Champ1=xxxxxxx WHERE LEDef_PK=1245
objUpdateModule.CommandType=adCmdText
objUpdateModule.Execute
Could you tell me what I have to put instead of "=xxxxxxx"
Anybody know how to do a SQL Update in asp.net using the OleDbCommand Parameter. that has a parameter that is to be NULLED?
sqlCommand.Parameters.Add("@date", ????);
is what i need to do the update w/ a null specifically i am updating Nulls to a date field in my DB.
I've got a page with a DetailsView. It uses a SqlDataSource which itself
uses stored procedures for Select and Update.
I don't want the user to see some of the columns, but if I don't bind them
(or if I do bind them but set Visible=False), when the Update procedure is
called, the parameters corresponding to the columns that weren't bound to the
DetailsView are all null.
This can't be an uncommon scenario, so I guess I have missed something. Any
ideas?
I am attempting to pass null as the input value from a series of
textboxes if the user does not input a value prior to submit. To try and do
this, I am using a vbscript function on this asp as follows:
CommentsAdd = IIf(Request.Form("Comments")="",NULL,Request.Form("Comments"))
I was hoping this would convert those emptystring textboxes to null.
Then, these variables are input in an update stored procedure called from
the same asp upon submit. This handles ntext and like fields in the table I
am updating, but a null value passed in this way for a numeric field chokes.
The error on the asp is something like, "unable to convert value of type
text to numeric". Can't null be passed as a parameter value when the field
type is numeric?
How does one pass null for a parameter's value in a stored procedure on an
asp? Am I missing something here?
I'm trying to update my database fields Employee, Status and Location with values from a form. Is this going to work?
Dim strEmployee, strStatus, strLocation
strEmployee= request.form("Employee")
strStatus = Request.Form("Status")
strLocation = Request.Form("Location")
SQLstmt = "UPDATE Table SET "
SQLstmt = SQLstmt & "RS("Employee")= strEmployee"
SQLstmt = SQLstmt & "RS("Status")= strStatus"
SQLstmt = SQLstmt & "RS("Location")= strLocation"
I am creating a form that uses a postcode lookup that opens in another window to confirm an address how would I pass back the address and populate the form?
View Replies View RelatedIs it possible to do an update on a recordset like this?display all the fields in a form and let the user pick which ones to update? What happens if they pick, say, two of the total to update, and leave the rest of the form fields blank? Would that update the chosen records and leave the rest of them blank or null?
View Replies View Relateddocument.forms[0].Update.value='yes';
document.myForm.submit;
in a routine.
I have declared a Hidden field called Update in my form. I have checked before the submit that the value does actually get set, but after Submission the value of Update is empty. I have checked everywhere and this is the only place in the page that this value is set.
Does anybody have any idea why my value is being lost on submit. My form is declared :
<FORM NAME="myForm" action="AgentDetail.asp" method="post">
I’ve been racking my brains trying to figure out why when I call a record set back with a SELECT * it only brings back some of the fields. It use to be connecting to an access 2000 DB and worked fine but I’ve converted it over to SQL. I’ve installed SQL server DEV edition and imported the data. The desktop is running XP.
Has anyone got any ideas why it only picks some of the fields in the record set and not others? O I’ve tried timeout = 0 on the connection already..
I am currently mantaining a website that uses only ASP pages. All my pages work unless / is added to the end of the web address. In cases like this the page is displayed except that the stylesheet isn't recognized. Any thoughts as to why this happens? Is it a problem in the code?
View Replies View Relatedhow to update and retrieve ntext fields in my asp code:
View Replies View RelatedWithout writing a bible on what I'm trying to do I'll see if someone
can answer a quick question.
I have a form that the user writes a value in a test field. I need to
put a hidden value that will take the same number the user inputs and
insert it in a form.
Basically, I need ...
<input name="hdndkqty" type="hidden" id="hdndkqty" value = ??? />
the value of the hidden field to = <input name="num" type="text"
id="num2" />
i just wanna know how to be able to update certain fields without touching the others
for example if the form has 3 fields
description, name and age....
if i wanted to update the database from these fields, but only update the description while leaving the ohters as they are, which means blank fields in form...
now if i do that on my form, it will clear other 2 fields in the database and only update the description... how can i fix that so that when there's blank fields in form in won't clear the data in database ?
This is probably a easy answer for you guys. Just trying to find the easiest way to do this. I want to click on a link and update a field in a recordset, but don't want
to leave the current page.
HrngID is the link. I want to change the Canceled field from a 1 to 0 when clicking on the link . I know I can use a onclick event, but not sure if these is an easier way. Can I do like a onclick and run a SQL statement on one line?
I am using Windows XP profesional and Access 2000 but are experiencing
problems updating or adding new records to my database with asp.
I have installed IIS 5.1 on my computer but also on my internet site I am
having problems to add a new rec. or update one.
The error message is something like:
< Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query. >
I get this message on my web site as well as when I try some new tests, with
other databases, on my local PC's IIS. Does anybody know what is wrong? It
used to work okay earlier on my web site?
i can add the record in first table but cant get it to do with the second one one of the field in the first table the "mktid" which is the primary and is a forgeiner key in the second table how can i have it insert or update in the second one Code:
View Replies View Relatedadd/update a record in first table and 2nd i can add the record in first table but cant get it to do with the second one
one of the field in the first table the "mktid" which is the primary and is a forgeiner key in the second table how can i have it insert or update in the second one
addnew.html
Code:
I have a table in the db and one field in the db is an email field various records can have the same email address in. When an email address changes from x to y I want to be able to change an email address x in every record in the table to y, how would I do this?
View Replies View RelatedASP VB. I have 1 recordset where I pull the order in.
I have another that I pull in the on-hand qty.
I used a repeat region and now I have it working to display the new on-hand qty. Now I just need to update the recordset with the qty on hand.
ok im trying to update a record.. i have my edit form working (i think) and now im just making the code to update that record..
im gettin this error tho
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Code:
I have to compare 2 tables: orderA and orderB, if the record exists in both table orderB and orderA, just do a update to the quantity field in orderB (add orderA.quantity to orderB.quantity). Otherwise a new record has to be insert into orderB.
Do I have to loop through the recordset of orderB, then use select statement to see whether the record exists in orderA or not, and determine whether to update/insert record? I am using Access database. I just afraid that looping through each record in recordset (maybe >=30 record each time) would make the transaction getting slow (or even hang??). Can I do this in one SQL statement?
I have a .asp page that displays an HTML page: view_msg.asp
There is a link (anchor tag) on that page that when clicked, sends the user to another page. I would like to also execute a MySQL query when that link is clicked. The DB is already open and connected to the page. The current current tag looks like this:
<a href="view_messages.asp"><IMG SRC="example.gif"></a>
and the MySql command I want to send is:
UPDATE Messages SET `fromDisplay`="N" WHERE idMessage=" & idMsg "
In english: When someone clicks on the link I want to execute a MySQL command to set the field value to N... how do I do that?
I know this is a very rookie question - but I don't know enough about asp to know how to execute the command here the way I want. Do I have to turn the image/button into a <FORM> 'submit' button</FORM> and use a redirect? Or, would I use an ONLCKICK. What would the correct syntax be?
i'm trying to figure out why i can not update a record if in the text box there is a ' anywhere in the field..
View Replies View RelatedI'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: ....
how to Update Record On Page Load. I have one feild in my database that I want to subtract 1 from each time the page is loaded.
View Replies View RelatedI have a form on a website for logged-in customers to update their contact details, when the customer update their contact details it should update the record in the database and at the same time the updated contact details should be sent to me by email.
I'm not an expert in ASP 3.0 and therefor I'm using dreamweaver 8 to create asp pages(ASP 3.0 VB), but dreamweaver does not have such kind of fuction(server behavior) to do this and so I have to create this by hand.
Now I already have page with the form that updates the record in the database, and I also have another page that does the mailing(CDONTS), first it updates the record in the database and in dreamweaver I have set "after insert the record go to mail_processing.asp" , but this does not work.
I can only get one to work, either only update the record or only mail the form data.
How can I make it to update and mail at the same time?
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: