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 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"
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'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 am running an sql statement to retrieve the values entered for a particular month. If nothing was entered by a particular user for a particular month, it will return null. However, I need a null return to be set to 0.
The variable "returnValue" holds the (you guessed it) returned value. I've tried everything I can think of, and no statement will turn the null value into a zero. Code:
I have an interesting situation that needs to be addressed ASAP.
I am running a standard SQL Query in ASP to retrieve some rows/columns from a table that's on a SQL Server 2000 database. I put the results of that query into a RecordSet, and then use the GetRows function to push the results that are in the recordset into an array variable. In the query that I am running, 39 columns and 2 rows are returned.
The GetRows function appears to be working - the array variable is being created with the proper dimensions. However, the values of the different "cells" of the array are not showing up correctly. The first and the last column values for each row are correct, yet everything else in between is blank, empty, NULL, or whatever.
In other words: ArrayVariable(0,0) shows up correctly, ArrayVariable(38,0) shows up correctly, but everything in between is null.
I did a test on the RecordSet and discovered that it was the culprit - it wasn't being filled in properly. This is strange, though, because the select query that I run in the ASP code to create the recordset returns perfect results when I run it on the SQL Server 2K database.
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
I'm given the oledb string, I would like to connect to ms sql server database through the ASP server programming language, if any one will walk me through this it will be much appreciated also how to query the database once connected?
View Replies View RelatedI have run in to a very frustrating error.
I get this error:
Microsoft JET Database Engine error '80040e24'
Rowset does not support fetching backward.
Now I know it must be a cursor but I have tried every cursor under the sun but to no avail.
Just a few notes. The line that gives the error is
[VBS]oRS.MoveLast[/VBS]
I am using the JET.4.0 Driver to open the database.
Anyone ever run in to this problem? I have used this sort of script 100's of times with absalutly no side effects...until now Strange thing is the recordset doesn't support Bookmarks either (second )
I was trying to setup IIS, ASP and MSDE 2000 Rel A on a machine yesterday and my usual SQL server OLEDB dsn-less connection string would not work on this machine. I know it's down to this, as I used a tool called QTADO to setup dummy data in the db and I had to use an ODBC dsn-less connection to connect to the db. I couldn't use the program's default OLE DB method.
The machine was WinXP Pro SP2 (might have been SP1), but I thought the OLE DB thingy came as standard on this OS. I didn't have chance to try the standard SQL ODBC connection string, will do this on Wed, but I'm sure it will work. Any ideas why the OLE DB wouldn't? Just kept getting General Network error on Connection (read).
I've managed to run procedures with an output parameter, but a return value
from a function is sufficiently different to stump me. Code:
When I connect to a MS Access 2000 db with no password using a OLEDB string is no problem but if the db is protected by password I get this message:
"Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
The string used is this:
"Provider=Microsoft.Jet.OLEDB.4.0; Password=xxxxx; Data Source=" & Server.MapPath("xxxxx")
Does anybody have a clue?
I have a OLEDB Connection String that is working very well for me. My
question is that I read that you can store the Connection String in a
seperate include file or somewhere else. I am just wondering where is
the proper place to store this Connection String and how do I call it
from my application. Code:
Is it possible to use data shaping in asp using Microsoft.Jet.OLEDB.4.0?
I tried it, but it returns an error saying that I must only use Insert,update,select,etc.. sentences only....
I have a simple database. I can get the data from the database and display them on a web page without any probs.
My problem comes when im trying to insert new records into it. When i submit the data i get an Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot Update.
Database or Object is read-only.
I've tried looking at the properties of the db but i can't figure out why it is read-only.
i have one .htm page passing the info onto an ASP page and then showing the results on another page. The code for my two pages are (if it helps): Code:
how its mossible to someone update may database, for now we have a database
and time to time, someone update a record, changing the information.
what can i do to avoid this?
can any one provide me with script where i can add to my database table using csv file and web form.
View Replies View RelatedI have an employee directory asp application. Everything works the way its designed but I want to make some changes. When someone does a search it of course comes up with a list based on their search.From there they click on the persons name and it opens the edit asp page which they do and update.
What I'm hoping to accomplish is to some how save the search criteria and one they update the page it will return to the previous page and redo the search so they don't have to redo the search to do another update.
I have a table called WGDeliveryNotes which has a field in called TrackFlag1.I would like to update the TrackFlag1 field to contain a value of 1 when the page is loaded..... I currently have this set within the ASP tags at the top of the page, thinking that this would update the field as the page loads however this doesn't seem to be happening.
View Replies View RelatedOn a database how can i update has i tried RS update and it does not work.
View Replies View Relatedi have 2 databae files in MS ACCESS format and i have already connected them from 1 ASP file and now i need 2 update the econt 1 from the firt
in another words :
i have 2 access databases
the first which is called 1st.mdb i allowed my visitors 2 rigseter and edit their membership in it across my website.
the second which is called 2nd.mdb have the same structure of the first(tables and fields) but in another url. hat is the best way 2 update the 2nd.mdb from 1st.mdb of course i donot wanna caopy and replace i need some programmatical method.
I have found out that when using dreamweaver MX 2004 to update databases, and specialy for amatures such as myself, it is easier to update one field at the time. Other wise you will get an error message on the line stringname.execute (usually line 111).
The problem is solved by updating only one field at the time. It might time a little longer but saves headaches when you don't know exactly how to work with the code.
I need help with fixing my code below. It doesn;t work correctly. It works fine when there are 4 featured records. But I want to be able to change one to not be featured (equal to 0). This is not possible with my current code. It shows the same message about me not being able to have more than 4 featured records. Can someone please help me with this?
Code: ....
I have a problem when i try to update a database!!! I am requesting a firstname text field from a form and an id number to find the row in the database.
But when i execute the following code to update the firstname i get the error:
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. Code:
The code that i have presenting allows me to view the database entries and to choose what i want to edit and then to do an update. Its not allowing me to save my new changes back to the database. Code:
View Replies View RelatedWhat i want to do is, I have an excel speadsheet that scans items and then fills in other fields (if that makes sense), what i want to know is I want to insert that info from the spreadsheet into a database used on a web site, line by line would be fine, i can do the insert bits fine, and the loops but, first is it possible and how do i link to the spreadsheet and get the info?
View Replies View Relatedi am getting a prob. in database id is a autonumber .i want to update value after retriving the va,lue from database .that is going on i mean retriving valuue from database but not update. Code:
View Replies View RelatedI'm having a spot of trouble trying to update fields in a access database using asp. I can delete and add fields thru the asp page but when i attempt to modify the fields i get a page not found error message. Code:
View Replies View Relatedhow do you create a link that will add 1 or subtract 1 from a number in the database?would it have to call a function that would do it or would i have to use buttons that did it?
View Replies View RelatedWe have a fairly large datbase containing thousands of part numbers, product names and pricing. We used to update new pricing changes individually by hand. However, now that our database has grown substantially, I'm wondering what the best method would be to keep the pricing current on our database?
We can obtain new price lists in excel format, however, the part numbers the mfgs use may not necessarily coincide with the part numbers we have. Should I just write some SQL script? Look into using XML? What would be the most efficient way to tackle this problem?
I want my users to be able to update their data(they store hours spend in different courses per week) stored in the Access database. So far they are able to update only one record(i.e. for only one week).....all they do is search for their records using their User_Id and click the WeekNo they want to update.
when there are (e.g. WeekNo1, WeekNo2.....) the user can only update data for WeekNo1 and when they click WeekNo2 the link takes them to WeekNo1 data.Please guys I need help cos I've been trying so hard to figure out what might be the problem and failed.