Detect A Null Field
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?
View Replies
ADVERTISEMENT
How to detect field's type in asp with accessing sql server.
View Replies
View Related
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.
View Replies
View Related
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
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
Is there a way for asp to know what url is in the address window? I have a function that is included in every one of my pages and I want it to write out different things depending on the page the visitor is on.
View Replies
View Related
Can anyone tell me how to detect a ip address behind a router?
I know that using ASP, we can detect the actual ip and the proxy ip, but what if the visitor is using a router that dynamically assigns a ip.
View Replies
View Related
I am using a stored procedure that outputs multiple recordsets.
I use <% SET rsDisplay = rsDisplay.NextRecordset() %to step to the
next recordset.
In one particular condition the final recordset is not passed to the
page, so I need to detect that the object is empty.
I did just try <% If NOT rsDisplay.EOF Then %but I get:
Microsoft VBScript runtime error '800a01a8'
Object required
Any ideas how I can trap this error? I just want the area on the ASP
page not to display when there isn't a final recordset.
View Replies
View Related
What I need is a field that is a drop down and when selected if less than four it needs to show a new field to select.
Once the total of the drop downs adds up to 4 or above then no more are created. This would be in the middle of a bigger form. Code:
View Replies
View Related
I'm working on an app to upload pictures to my Web page.
As part of it, I need to know the dimensions of the
images - how many pixels wide by how many pixels high. Is
there any way, as part of the upload or immediately after,
that I can detect that?
Also, though the solution isn't exactly appropriate to
this NG, I would also accept a client-side solution to
this problem.
View Replies
View Related
Normally I would do something like
if request.form("submitbutton.x") <"" then
....
end if
But I found a problem when the browser uses the 'alt text' instead of
the image (when the image is not found, or if the browser is not
displaying graphics, etc. How do you detect that? or should I?
View Replies
View Related
Does any one know how to detect if a user is using IE on a Mac so i can route them to another page.I have tried the following:Code:
strUA = Request.ServerVariables("HTTP_USER_AGENT")
But how do i parse this info to determine whether they are a MAC IE user ?
View Replies
View Related
I am working with a bunch of old code so I can really restructure the includes, otherwise I guess I could change all the #include statements to #include-once. Anyway, If I have a file with a class like this:
Class myClass
end class
I get a "name redefined" error. I've been seeing these and indeed from goolge searches, it's because the file is somehow included more than once. This problem doesn't occur for functions and the old code bases just used functions whereas I would like to add some classes. In C you used to be able to detect that at the top of the file and not included the rest of the file if it is allready included. I just want to at least detect it so I don't redeclare the class.
View Replies
View Related
How can I get the url of a page in asp and detect if there are no variables appended to the end? Would I somehow get the address and do an instr for the ? character? Code:
View Replies
View Related
Could anyone show me a tutorial or like show me a script in asp that can detect to see if the mysql backend is working? And if it isn't then to display a message that says something like "out of luck."
View Replies
View Related
Is there any way to detect JavaScript using ASP? I need a script that does something like this:
If JavaScript is enabled (is supported)
write this code
else
write this code
If not, can I do it with any other language?
View Replies
View Related
Is there a way whereby i can detect where the user came from?
For example:
if this user came from www.mywebsite.com/a.asp theni will redirect him to c.asp but if he came from www.mywebsite.com/b.asp then i will redirect him to d.asp
View Replies
View Related
I need to add in some specific browser detection in my ASP to identify Mac IE5 running OSX - is there any wahy of identifying this config alone - and not just identifying all Mac IE5s? If you have OSX Mac IE 5, please visit this page which will give your User Agent string.
View Replies
View Related
Is it possible to detect downloads of a file on the web server? Using ASP Classic?
View Replies
View Related
The delete method of the FileSystemObject.FileObject does not return a result. If permissions disallow deletion, it will not raise an error. Conversely, if the delete method does succeed, a call to FileExists directly afterward may return true because the system hasn't updated yet (or whatever actually goes on). Is there any way to accurately check the result of a deletion?
View Replies
View Related
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
View Replies
View Related
I searched around everywhere on the net, but could not find a simple example
of detecting if cookies are enabled - on server side, and without moving
from one page to another.
This should be a very basic functionality, so I am reluctant to believe that
there's no way to simply test it in a server-side script.
View Replies
View Related
I've been working on this wysiwyg web editor. The editor lets you upload images. Only .jpg, .gif and .png files are allowed. Now I should be able to detect if the uploaded .jpg image is in RGB or CMYK mode. Only RGB images should be allowed. Can this be done with ASP?
View Replies
View Related
I need an asp page that will detect the clients java version, and then email the results automatically.
View Replies
View Related
I'm trying to write an ASP interface that mimiks a .Net datagrid control.
I'm having a problem when I'm in the middle of an Edit, Update, or a New
Record.
If the user hits the wrong button, the program grabs the values in
the textboxes using the request.form() and then redisplays them in the
textboxes when the records table gets written back out to the page. This
works fine as long as the form is submitted.
If it's just a page refresh
(F5), the program doesn't get the latest changes to the textboxes and
displays either a blank or whatever was in there the last time the form was
submitted. Anybody got any ideas?
View Replies
View Related
Im writting an asp app that tracks the users scores and info (its a
training app) to a access database, ive disabled the ie toolbars and
everthing so the user must use my nav buttons so i can track what pages
they have been to.
My problem is if the user closes IE with the close button [X], is there a
way i can redirect them to my close database and save results page, i cant
use the unload event as this is trggered every time the use goes to the
next page.
View Replies
View Related
the way a field is currently displayed:
Currently the ASP code inside my page is simply:
<%=rs.Fields("Notes")%>
This is fine for displaying the text, but the text contains links which are
currently just being displayed as text. I'd like them to display as
hyperlinks that will open in new windows when clicked upon. so basically I
need some ASP code to detect text starting with http:// or www.etc and
automatically make them into hyperlinks.
View Replies
View Related
I have a function in a script file that I use from a couple of different pages. Can I, within the function, detect which page is being viewed (which page called the function)
View Replies
View Related
I am looking for a snippet that contains a comprehensive list of browser detections, where I can tell each browser, platform to load a different .css file.. any ideas? Thanks!
View Replies
View Related
I would like to know how to detect if a graphic has been downloaded using ASP, can anyone advise?
AUTOMATICALLY without click. So if i hit a page on my site, it should detect it and store in a database. Is this correct?
View Replies
View Related
How can I detect if someone is browsing with a mobile phone or other small screen device?I'd like to give them a text and small pic version of my site.
Also, what media player is common to them, and is it programmable, ie, can I turn sounds off and on.
I have an interactive page with alot of text, I'd like to offer the interactive page without the text. Do they run javascript?
View Replies
View Related