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

...CREATE Procedure sto_GetCases @cac_chd_id int AS SELECT CAC.CAC_ID, REFERRALS.REF_EMP_REC_DATE, CAC.CAC_CASE_NUMBER FROM CAC,REFERRALS WHERE CAC.CAC_ID*=REFERRALS.REF_CAC_ID AND CAC_CHD_ID = @cac_chd_id AND REFERRALS.REF_EMP_REC_DATE > '1/1/1950' ORDER BY CAC_ID Thanks, Debbie

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!!!!!!

...-- ORDER BY REQ_DATE OPTION(FAST 1000) END ---This will be the second query.... BEGIN SELECT @TOTALCOUNT = COUNT(*) FROM #LOC_tKey WITH(NOLOCK) --RETURN 1 SET ROWCOUNT 1000 SELECT #loc_tKey.RowID, #loc_tKey.FolderID, @TOTALCOUNT as TOTAL_COUNT...

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