What's the best way to handle passing a null value to a number field in my Access database? Right now I am getting an INSERT INTO error when I am doing this. I tried doing the following:
Mon = Replace(Request.form("txtNewMon"),"","0") but it doesn't seem to work. Would you suggest doing an IF satement?
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'ContactID', table 'ka0506a.ka0506a.contacts'; column does not allow nulls. INSERT fails.
/submitcontact.asp, line 15
What happened is i used to used MS Access and ContactID is an Autonmuber field, and now my connection is set to MS SQL so it's giving me this error, what's causing this error to happen and how can i change it ?
I have a condition that will run depending if a field in the database is NULL. It will not run at all, and I tried various way to write it but none works so far
'not working
If assignee = DBNull Then
'not working
If assignee = null Then
'not working
If assignee = "" Then
If I write assignee to the page then the value of assignee will write if it has a value and nothing if it is null.
I have a field called w. The data type of the field is number. I use Access database. I cannot update a null value in the field.
r3("w")="5"
r3.update
I have a 'brief' field (varchar, 2000 characters) that I sometimes want to leave Null. Getting SQL Server to leave a field Null is no problem, but getting ASP to differentiate a Null field from a populated one is proving a real headache!!
How do you do this? I've tried:
If Len(objRS("f_brief")) = 0 Then... etc.
But it seems that Len(objRS("f_brief")) = 2 with a SQL Server database (though I've no idea why!!) Any ideas as to the best way to detect a genuinely Null (not just empty) field in a SQL Server database with ASP?
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 trying to update an integer field in an Access database with a null value (ie, make the field empty). It currently has an integer in it. Here's the code I've tried, which normally works for all other updates:
set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = sConnString
rs.Source = "SELECT * FROM tblFixtures WHERE FixtureID = " & strFixtureIDcurrent
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 3
rs.Open()
rs_numRows = 0
rs("ArticleID") = ""
rs("Result") = ""
rs.update
rs.close
set rs = nothing
However I am getting a Type Mismatch error on the rs("ArticleID") = "" line. Where have I gone wrong?
It shows the data but not like in the data table (Access). I would like that the numbers have a 2 digit decimal behind the comma i.e.123.456,30 and negative numbers should be in red and in brackets i.e. (123.456,30) So, the format should be:
$#.##0,00;($#.##0,00)[Red] as I have done it in the table - but not in ASP
Where do I have to enter the format in the ASP code? - or - Where do I have to enter the format in the Html code? Is someone able to write me the coding line?
i need my field that is 10.00 and turn it into this 00001000 any ideas.
View Replies View RelatedI have one auto number problem in one table in sql server 2000. I'm inserting new record using insert statement and am not giving any value for that field as its auto number.
On the very next statement , I need to know which number it inserted in auto number field for that record??What should be the logic?
How would I change the following update statement so that if one of the AreaCode fields was blank, that it passes instead of saying Syntax error in UPDATE statement?
Quote:
sqlString = "UPDATE Installers SET Company='" & Request.Form("company1") & "', [Contact]='" & Request.Form("contact") & "', Phone='" & Request.Form("phone") & "', Fax='" & Request.Form("fax") & "', Email='" & Request.Form("email") & "', Website='" & Request.Form("website") & "', Address='" & Request.Form("address") & "', City='" & Request.Form("city") & "', State='" & Request.Form("state") & "', ZipCode='" & Request.Form("zipcode") & "', Country='" & Request.Form("country") & "', AreaCode=" & Request.Form("areacode1") & ", AreaCode2=" & Request.Form("areacode2") & ", AreaCode3=" & Request.Form("areacode3") & ", AreaCode4=" & Request.Form("areacode4") & ", AreaCode5=" & Request.Form("areacode5") & ", AreaCode6=" & Request.Form("areacode6") & ", AreaCode7=" & Request.Form("areacode7") & " WHERE Company='" & Request.Form("company") & "'"
Using ASP, how would I make a field in an entry 'blank', baring in mind that its a number field. I have tried...
RS.Field("ReviewID") = ""
and
RS.Field("ReviewID") = vbnull
But it doesnt like either of them.
i know in html you can set a "max" character limit for a form field.I was wondering if it is possible to set a min number of characters?
View Replies View RelatedI am using filter to build a recordset of records using:
Recordset1.filter="sorter >'"&todayDate &"'"
I dont think that the sorter field is a number, so how can I ensure this at this stage?
I have a table [table] with two fields [type] and [ID]. I am trying to create a table with the number of IDs per distinct type. So, the return table would be {distinct [type]}, {count per {distinct [type]}. I am stumped; I believe this must be two queries?
View Replies View RelatedI want someone to enter an area code in a field. They would hit search, and it would pull up all records whose phone number starts with that area code entered. Code:
View Replies View Relatedsqlstr ="INSERT INTO BorrowerTab VALUES('" & strName & "','" & strEmail & "','" & strPhone & "')"
These are the 3 fields i wish to insert value.
I cannot do it because there is an auto-number field in my table.
How do i tackle this ?
The error tht i get is query or destination are not the same
What I want to do is pass a Field value directly from the URL to the webpage content, but it's getting stuck and sometimes no values get passed? For eg:
Suppose my site is www.mysite.com/member.asp?id=25
I want the 25 to be placed somewhere on the member.asp page when the above url is hit.
I have tried <% =id %>
I have also tried <% =Request.Form("id") %>
I have a listfield that displays a list of 'Themes' stored in a database. The listfield's lable is Themenames and it's value is UniqueThemeID. The page that i'm designing allows the user to add or remove Themes to this list which updates the database.
When the user adds a theme i can use the UniqueThemeID (which is passed when the form is submitted) to display a page saying that "The theme *Themename* has been added to the database". My problem is that i cant do this when the user wants to delete the theme beacuse the UniqueThemeID no longer exists in the database.
So somehow i need to pass the listfields selected lable, maybe with a hidden field of something, but i'm stummped as how i can do this. Does anyone have any solutions. I sure other people must have had this problem in the past, but i cant find anything on it.
I have an asp page that allows cdont mailing of form field values to persons matching slected criterea in their profile.
Works good if the user goes straight from the form to the email-making asp.
Then the user asked for a proofreading screen and what seemed simple took a bad turn.
When I try to pass from the proof reading screen to the asp that actually sends the email I only get the first word. as soon as a blank is encountered in the text it thinks it it done. Code:
I have a working .htm form residing on my server. On submit, I would like to pass field varibles to .asp form on another server. The .asp form needs to be populated with passed varibles and submit button executed automatically.
Is there any way I can pass the value in a disabled text field without creating a hidden field?
View Replies View RelatedI currently us JavaScript to populate a hidden field with my scroll
location in order to retain the page location when I post the page back
to itself. However, I don't know how to pass that hidden field value
in a hyperlink as the value is always changing. Anyone have any
suggestions?
how to i passing values to text field?
<input type="text" name="Usrname" size="20" value=<%= fullname %> >
i knew this is wrong.. but how do i solve this problem?
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 have two asp pages, one collecting value in a for the other displaying those values.
Normal non-hidden text fields are displaying properly. But my hidden field is not. The hidden field is made up of 3 other text fields and joins them together. This page collects and sends values (i only included the item in question) Code:
I have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?
View Replies View RelatedI need to insert some number into database as text. My problem is if I insert the number (ie. 4.0), the value in the database only show (4). So, is it possible to convert a real number into text number using ASP?
View Replies View Relatedhere is the scenerio
in master batch table i have various master batch like
200701-0001
200701-0002
200701-0003
Now each master batch can have multiple final mixed batch like
200701-0001-01
200701-0001-02
200701-0001-03
and this record is inserted in to fmix table.
so i have a form in which i have a dropdown menu in which all the master batch is listed,
i select 200701-0001 and that value is passed to next page where i will enter other fields data and insertion to my fmix_no will be done automatic like 200701-0001-01, 200701-0001-02 and so on,
how to achieve this
so in short each master batch will have more than one final mixed batch.
pls help, also if u have any online contact in yahoo or msn pls send me, i am so confused and badly struck deadline is just couple of hours away. my yahoo id is(E-Mail address blocked: See forum rules) you can PM me i am online right now.
I want To handel the error messages by myself in one part in my script. I know that in VB I can Use the statment - On error resume next And I also know that I can retrive the Error Number In VB with Err.Number.
How can I handel the errors by myself in ASP? I heard about the ASPErr Object, Is it the same thing like the err object in VB?
I am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate
Home
Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer)
GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
I have created a table. How do I limit the result of that table to only show the entries that have the "address" filled in. In Access here is the sql coding to acheive the results.
SELECT Dropoffs.City, Dropoffs.StateInitials, Dropoffs.AcceptedItems, Dropoffs.MoreInfo, zipcodes.Address
FROM zipcodes, Dropoffs
WHERE (((zipcodes.Address) Is Not Null));
How do I set this up in my VBSCRIPT page?
Here is my working page so that you can see what I am trying to acheive. When the page comes up you can type 45255 for the zipcode.