IsNull & IsEmpty Not Working?

I have a database that has "thedate" as a required field. The form that I'm using to insert data allows you to leave the date field blank. If left blank, I want to automatically insert today's date.

If I fill in a date, it works fine & the data is inserted. But if I leave it blank I get an error. This is my code:

View Replies


ADVERTISEMENT

IsNull And IsEmpty

there is no row in the table, totally empty so i try to use IsEmpty and it never return true. and isnull and isempty whats the difference?

Code: ...

View Replies View Related

If (IsNull)

I need help on an "If (IsNull)" issue. I'm opening a record where "Project" is a certain name. If there are publications associated with the project, I need the title "Publications" to print and then a list of the publications. This works great.

I want nothing to print when there are no publications associated with the project. The code below searches the "Magazine" field. If it's empty, nothing prints. The only way I can get this to work is to associate a empty publication to the project so that the query will return at least one record with an empty "Magazine" field. What I need is if the query returns nothing then print nothing.

CODE: ....

View Replies View Related

IsNull Check

In my functions I'm using a double-check all the time to trap if a value has
nothing in it and my question is do I need this double-check.
My check line is:

IF IsNull(xxx) OR LEN(xxx) = 0 THEN

blah blah

ELSE

blah blah

END IF

xxx is usually an array built up of data from an ADO recordset so will
LEN(xxx) = 0 cover my zero values or do I still need the IsNull check as
well?

View Replies View Related

IsNull Update Statment

I need to know how to do this IsNull update statment in ASP:

"UPDATE tblUsers SET username='" & lcUName & "', hash= IIf(IsNull([lcHash]),"",[lcNewHash]), inactive=" & llAct & ", locked=" & llLock & ", isadmin=" & llAdmin & ", attempts=" & lnAttempt & ", lastlogin=" & ldLastLogin & ", onlyreadaccess=" & llOnlyRead & " WHERE UserID = " & lnSetID

View Replies View Related

Memo Field And Isnull Issue

i am testing if my memo field (access DB) has anything in it by doing

if isnull(rs("memofld")) then

do this

end if

The script is not picking up a valid value if it is null or not. I have also tried testing for it equalling "" but no lick either.

Read alot of stuff online with people having the same problem but no luck. I have tried selecting the memo field last in the sql query but this makes no difference.

View Replies View Related

IsNull Function Requires 2 Arguments Error

I used this to sum column with nulls and it worked fine but then when I tried to do the same with the next column over, I get "IsNull function requires 2 arguments error".

In my select statement:

Sum(IsNull([1st Qtr],0)) as Sum1QN

The one above worked fine, so I thought I would just do the same for the next column over like so:

Sum(IsNull([2nd Qtr]),0)) as Sum2QN

View Replies View Related

Isnull And ""

What is the difference between not isnull(val) and <> ""

can this statement be reduced from

If NumberDep <> "" or not isnull(NumberDep) then HBinsertSQL = ",
NoOfDependants = " & NumberDep

to

If not isnull(NumberDep) then HBinsertSQL = ", NoOfDependants = " &
NumberDep

I would like to know what the difference is and if possible any links that
have a good description

View Replies View Related

ASP Not Working Ok In PWS

I just installed PWS on 2 machines (XP & 98).

The problem is that I can run the ASP files in the wwwroot folder when I use http://localhost from my browser or RUN (and that's for the default.asp). But the asp files do not work when I call them from a hyperlink in an HTML file.

View Replies View Related

CDO Is Not Working

After I moved the site to new server the mailing method stoped working , the cdo pull the email from sql database on the same server .. although it says sent to # recipients.
I send a webpage (newsletter) exisit on the server "I use full url" also the registration page gives when registration the error: CDO.Message.1 error '80040218'

Unknown Error

/extra/news/reg3.asp, line 251

line 251 is objSendMail.CreateMHTMLBody "http://www.example.com/newsletter.html"
I saw description of the error it sayes that I have to use full url ...but I am using it ...
any Idea ...

View Replies View Related

Asp Working Or Not

I have a sever 2003 machine of which I am trying to host a webisite on. The webpages I uploaded has lots of .asp files that could not be open. I'd contact the website disgner and complains about it and an he blaims it on my server not supporting asp technology.
My question today, is there a way to test what the problem really is?

View Replies View Related

FSO Not Working

In my serverside script I have gone down to the bare bones and the following doesn't seem to work:

dim fs
dim fst
dim LineOut
set fs = Server.CreateObject"Scripting.FileSystemObject")
set fst = fs.CreateTextFile("C:TEMPhome.tmp",True)

lineout = "MAFFIdentifier" & vbtab & "Title" & vbtab & "Initials"
fst.writeline(lineout)
lineout = " ==================================================
========"
fst.writeline(LineOut)

fst.close
set fs = nothing

The server gets to the end since I place a response.write in to test.

If I cut and past this into VB declare the variables as objects and lineout as string and remove the "Server." from the line when setting fs, then it works fine in VB.

View Replies View Related

Not Working In PWS

The problem is that I can run the ASP files in the wwwroot folder when I use http://localhost from my browser or RUN (and that's for the default.asp). But the asp files do not work when I call them from a hyperlink in an HTML file.If I do that, all I see are the contents of the asp file.

View Replies View Related

Getting Working

Just set up Dedicated Server Hosting with GoDaddy. I put a very simple ASP page in the home web directory and try to load it and get a very generic error. A simple HTML file works fine. Obviously it's a permissions issue or maybe some service is not running.

View Replies View Related

Sql Not Working In Asp

i got an sql sentence that is executed in toad without problem; returns 1 but when i run the sql in asp i get returned 0. Code:

SELECT COUNT(*) as st
FROM sest_sklepi
WHERE rok<(SELECT TO_CHAR(SYSDATE, 'DD.MM.YYYY') as b FROM dual)

View Replies View Related

ASP Not Working

New to IIS, Why will IIS 5.0 not server up my ASP web pages? I cannot even get to the help because it is an ASP Page. I get an error in IE that states "HTTP 500 Internal server error". I have looked in the configuration and cannot find anything related to ASP. What can I do to serve up ASP web pages?

View Replies View Related

Why Isn't My PWS Working

I'm having difficulties making PWS work. I have WIN98SE. It was working for a while but now it says:

Quote: Problem:
An unexpected error occured.

Solution:
Please restart the Publishing Wizard.

View Replies View Related

Working With Url

Im finishing up a content management system for a client. It works fine except the way they have the pages set its nessessary for someone to open each page made and change it to the new directory.

the script copys a folder from lets say

http://fake/templets

To

http://fake/user
so now we end up with something like
http://fake/user/smith

On the pages in smith is there a way to make the look at their url and strip off all but the /smith part?

Or maby someone could tell me what im trying to do is called and ill be able to do a better search online.

View Replies View Related

<>0 Is Not Working

Here are the scripts. interest is 0, but, it will not execute then clause. Why?

interest = round(rs("CURR_WORKING_INTEREST"))
response.write interest
if sizeworkint < 3 OR interest<>0 then CURR_WORKING_INTEREST2 =
left(rs("CURR_WORKING_INTEREST"),2) + ".000000" end if ..

View Replies View Related

ASPUpload Isn't Working

I just noticed my upload function isn't working since I have move the folders and files to different directory.

Now I get this error:

Error Type:
Persits.Upload.1 (0x800A003D)
Wrong Content-Type. Make sure you have included the attribute ENCTYPE="multipart/form-data" in your form.
/foldername/UploadScript.asp, line 54

line 54 is:
Upload.Save "z:
ewfolder"

I have given modify, read & write permission for IUSR_MachineName account on NewFolder and given Read & Write permissions in IIS.

I also included ENCTYPE="multipart/form-data" attribute in my upload form.

View Replies View Related

CDONTS Not Working

I'm using IIS 5 on a win xp machine for all my testing, before I upload to our live server. I've installed the SMTP service and it's running with no errors.

Dose anyone know anything about the above set-up not supporting "CDONTS.NewMail" for sending email using ASP..?

I get the following error message: "Server object, ASP 0177 (0x800401F3) Invalid class string".

View Replies View Related

Access SQL To ASP SQL Not Working

I have taken some SQL from MS Access and got it working. I have since updated the SQL in Access but cannot get the additional part working in ASP. The working SQL I have in asp is:-

strQuery = strQuery & " HAVING ((OrderQuantity-Sum(QtyShipped)>=0) AND
(OrderLines.SelectAll=-1) AND (PCBForecast.HeldMarker='Scheduled'))"

I need to add the following but keep getting errors saying my SQL is
incorrect.

This is the additional part which should also be on this line:-

AND ((PCBForecast.ShipETA) Between Now() And #12/30/3000#))"

or another variant I require

AND ((PCBForecast.ShipETA)=#12/31/3000#))"

What is the correct way to write both of these, as I cannot get either
to work in asp, yet they work in Access.

View Replies View Related

ASP Working With MS Office

I want to read the MS Word and XLS documents with ASP code for searching. Is
there are any solution for me or any reference?

View Replies View Related

If Statement Not Working

whati have is a table that alternates colour each row so making it easier to look at the info. I also have it to check so that if the stock level is below min change from standard to red.

I also want it to check now so that if it has been ordered instead of being red green instead. i thought this would do it but i dont know how to check database to see if the check box is ticked. Tried Yes/No True/False and even both "yes" or "true" and so on. Code:

View Replies View Related

Replace Not Working

my replace is not working
Shipping News ...i don't want news word ..mean i just want
Shipping
Code:

<%=Replace(rs("name"), "news", "")%>

View Replies View Related

Hit Counter Working

i want to add a hit counter to my site but i dont know any thing about it. can any one tell me how does it work.and what should i do for that?

View Replies View Related

Ad Rotator Not Working

I have the following ad rotator that dosent show any errors or pictures. In my root directory I have a folder called "ads" and in the folder there are a few gif's.

In my html folder I have the file called "banner-inc.asp" which contains the following code:

View Replies View Related

Get Sub Menu Working

I am generating my menu dynamically as a dhtml menu. however the third level 'MenuSubCat'. I cannot get it to display properly and to loop all the third level sub menus to correct second leve menu. Code:

View Replies View Related

Working With Dates...

I'm using ASP to access an MS Access database. One issue that I'm constantly
having problems with is Date/Time records.

What I'd like to know is how does one work with date variables in ASP?

My current problem is this...

I have two variables, Mnth and Yr, which each hold an integer. Mnth holds
between 1 and 12 ( a month ), and Yr holds the desired year (2005 for
example).

With only these two variables how can I generate a full date to use in an
SQL query, such as:

SELECT * From Table WHERE DateAdded>??<date value here>??

View Replies View Related

HTTP_REFERER Not Working

I am giving the following:

test = request.servervariables("HTTP_REFERER")
response.write test

It just gives me blank page and does not give me the URL. I tried request.servervariables("REMOTE_ADDR") it gives me the IP address but HTTP_REFERER is not working. What could be the reason.

View Replies View Related

ASP Stops Working

I am running win2k3, iis6, access db's, for a web app. The
problem is that asp stops working randomly. No errors in
IIS log, no errors in even viewer. It just stops serving
asp. Restarting IIS clears up the problem. This occured
under win2k but maybe once a month. Not that I switched to
win2k3, it happens 4-5 times a day. Any ideas? What would
be the difference?

View Replies View Related

ASP Page Not Working

The page code can be viewed at http://www.onthescene.co.uk/loginpagecode.htm
the error messages on both firefox and IE6 don't tell me anything other than its an 'internal server error'. Ive spoke to my web host and they say they can't help as they dont give programming support.

View Replies View Related

USER DSN Not Working

I am connecting MS Access Database from my ASP Page and trying all possible options. The DSN-less way works fine, even the System DSN and File DSN works fine, but the problem arises when I try to use the USER DSN. It just doesn't work. The error message I got is "Data Source Name not found and no default driver specified" It seems its looking for the system DSN only when I use the following code :

SET Conn = Server.Createobject("ADODB.Connection")
Conn.open "DSN=myUserDSN"

I have created the user DSN called "myUserDSN" successfully under the USER DSN tab of ODBC drivers. So why it doesn't work?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved