Search results for query: *

Hi there... I am trying to get a query that can find if a Loandate falls in last week...so basically check if loandate is between sunday or monday of last to friday or saturday of lastweek... Any clues: Select * from loan where last weeks sunday<Loandate>last week's saturday. Thanks:)

Just a quick question: How does DATEADD(d,-1,DATEDIFF(d,0,GETDATE())) represent yesterday's date... My explanation which does not fit here is that datediff will do today-0 and will return 8 as today's date is 8th. Then for DateAdd don't we need a date to do the calculation...how does it do...

wow--thanks j4 and clflava for your feedback. I am trying a couple of things here based on your suggestions..though I am unable to understand j4's code of innerhtml--sorry i have no clue what that is. Well now that you are bored---you can try explaining it to me...

Hi there...on my form, I have a text field that displays a number. I have a button next to it with the name "Change". I want to be able to click on "Change", so that the text field becomes an input field, so I can enter a different value and then the page refreshes to display the new value as a...

Hi I have 3 pages: Page1.asp, Page2.asp and Page3.asp. On Page1.asp <A href="Page2.asp?loannum=<%=RS("loannum")%>">Send to Page2&nbsp; On Page2.asp I have an onlick to this javascript: <SCRIPT LANGUAGE="JAVASCRIPT"> <!-- function Check() {...

Ya that makes sense. Okay I will go with response.redirect...Thanks again:)

Thanks Cory.....Its weird..the current code works fine...god knows why i need to change it...any other ideas or better ways of doing it???

Hey there...I have a perfectly working code where i click a button and the onclick--directs it to a javascript function based on if there is a record in the DB or not. However my boss suggested I not use javascript and do the same with asp....any clues? <form name="Page1" method="post">...

Hey Kaht---I had to change that coz it was erroring up on me. Now my code is: 'Check if record exists in servicing export table mySQL = "SELECT * FROM ServicingExportFields where loannum='"&request("Loannum")&"'" Set RecordCounter = Con.Execute( mySQL ) dim clickHandler if...

Hey Kaht--that kind of works--however whether there is a record of not...it always hits function 2 and never function 1...any clue why it would do that?

Hey Kaht...I tried the code as you told me and and it says 'clickHandler' is undefined on the line onclick="<%="clickHandler"%>" :(

Thanks Kaht..I'll take a deeper look into the code as you explained it quite well. Iam sorry if my red text showed I was angry--i just thought becoz of my long code...probably my words were being missed out so I wrote in red....never ment to be angry at all--on the contrary I am thankful for all...

Is my syntax to call the functions wrong?

Still Error--its just going to page cannot be displayed---am I missing something: 'Check if record exists in servicing export table mySQL = "SELECT * FROM ServicingExportFields where loannum='"&request("Loannum")&"'" Set RecordCounter = Con.Execute( mySQL ) dim blah =...

Kaht and DNG--the code is erroring up on me. Just want to make sure in kaht's code, the function1 and function 2 are ASP functions or javascript functions? If ASP functions--any clues on the syntax of the function and how to call it--sorry I am a newbie:(

Thanks Kaht..I tried your method. Just a question, can I send the value of the Stamp field to the clickhandler like onclick="<%=clickHandler('DM01', '<%=RS("loannum")%>', document.Page1.WareHouseNumber<%=RS("loannum")%>.value) %>"> Similarly in function 1 and function 2?

Thanks DotNetGnat....but this function calling should happen only when the button is clicked. And should I change to functions to ASP function rather than javascript functions?

Hi there..I have an asp page where I have a SQL statement which is checking if there is a record in the database. There is also a table on this page which has a button with an onclick javascript. What I want to do is that if there is no record in the database, the onclick should go to...

Hi there, I have a column in the table(Collection) called Contact where the data is in the format Name Ext eg. John lennon 1601. I want to write a query that will display just the name and another query that will display just the Ext--that is the right 4 numbers. Any clues what the 2 queries...

Works Like a charm--Thanks a bunch--i have been trying to figure this out for almost 2 days and couldn't get it out of my head even over the weekend. Now I get to enjoy the Week atleast:)) Thanks again!