Search results for query: *

Thank you sooooooooo much!!!!!!! Thanks, Debbie

I need exactly the same thing. Have you found anything???? Thanks, Debbie

I have a page that contains an image that was originally a lot larger than the screen so I reduced the size. I want the user to be able to click the image to view it full size in a new window. However none of the code I've found works the way I need it to. Since the new image is larger than...

Thanks tlbroadbent. It worked!!!!!

Thank you so much. I intend to learn as much as possible about joins. Thanks again, Debbie

Thank you so much. I don't know much about join's. Someone else wrote this code and I'm just modifying it. I will give it a try. Thanks again, Debbie

I'm trying to set this up so that it only gets those that have a REF_EMP_REC_DATE but it's returning a record that is in the CAC table but not the Referrals table. Therefore it's putting a NULL in the REFERRALS.REF_EMP_REC_DATE. I don't want it to return a record if there is not a record in...

There is a problem with this website and I keep trying to send this reply and keep getting an error message. Hopefully I don't wind up with this getting entered 5 times but here is my reply again: Thanks for the information on how to test it. Learning how to troubleshoot is half the battle...

I'm sorry but I'm not sure how to add a test of sSentence.

Yes it is a string. I tried what you suggested and I no longer get the error message but it still doesn't put a NULL in the database field. Is there a way to do it with a string? Unfortunately, the way the code is written it doesn't work with a space in the field. I could probably get it...

If someone does not make a selection in the dropdown menu box, it is considered blank. Therefore it should pass "NULL" to the database. However when I do the following code it returns an error message that says "Invalid use of Null". If Len(Trim$(txtSentence.Text)) = 0...

The cint worked but the trim didn't. It's interesting because we have several other places in the code where we do the same thing and they work without the cint. That's why I couldn't figure it out. Thanks!!!!!!!

I have some code that I want to run only if a condition is met. The Request Location has to be the same as the User Location. I put the following code: If (objFolderRequest.intReq_To_Loc = objUserLocation.intLocationID) Then However it is going into the Else statement as if this condition...

I'm trying. I've tried several things and they aren't working. Thanks, Debbie

Thanks for trying.

This is what I tried in the stored procedure and it didn't work. WHERE REQ_DATE = @datReq_Date like '%00/00/00%' It says incorrect syntax near like. Unfortunately the way we are passing the values to the stored procedure are different so I can't get it right. This is what we have...

I'm trying to do a search by a date but since the field also contains a time, it's not finding the date. I was told I need to use a time range but I don't know the format. Also, do I put it in the ASP code or in the stored procedure? Any help would be appreciated. Thanks, Debbie

It works!!!!!!!!! Thanks!!!!!!

I have a date field that is added with the current date using GETDATE. However I would like for it to add only the date and not the time. I found information in this site on how to select only the date when the date and time are in the field but I can't get the code right because of the...

Wow! That does sound great! I really like the idea of being able to see the variables. Since I'm trying to set up a shopping cart program that will really help. Thanks, Debbie