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 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 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:
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?
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.
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.
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.
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.
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?
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.
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:
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."
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
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.
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?
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
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.
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?
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?
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.
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.
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)
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!
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?