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

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() {...

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">...

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

Hi! I have a piece of code where the user picks a date from the calendar. Depending on the date he has picked, it should display all the days of the week. Example: If the user picked 18th October 2005 from the calendar, then it should display: Sunday 10/16/2005 Monday 10/17/2005 Tuesday...

Hi! I have a piece of code where the user picks a date from the calendar. Depending on the date he has picked, it should display all the days of the week. Example: If the user picked 18th October 2005 from the calendar, then it should display: Sunday 10/16/2005 Monday 10/17/2005 Tuesday...

Here's my code where the user picks a date and I want to use that value elsewhere. However I am unable to get the date value--any clues??? Iam using <%=gms("autonum")%>" with the PullDate becoz i have PullDate box multiple times on my page--so i need to uniquely identify it. Here's the code...

Hi there! I just need a small help with passing values via a javascript to the ASP page using window.open. I have 2 integer values on the page, one is a and one is b. I want to be able to pass c which is a+b to this page. Heres the code--any clue what iam doing wrong??? <SCRIPT...

Hi there! I need help with a sql query where i have a DateStamp column with values like 5/10/2005, 4/11/2006 etc. Now since todays date is 09/19/2005, I want to pull only those values that have year as 2005. Once the year changes to 2006 I want to pull values for 2006 only. So basically...

Hi there! I am trying to get a report for the current year. So i thought: (1) I could get Today's Date from the computer clock (2) Get the year from it. (3) Then in my SQL database "DateStamp" column, check if the Datestamp has Date Like the year from the clock. I dont know if this logic...

Hi! Here's my code which has 3 drop-down menus, one with Employee: which is fairly static, one with Month: and one with Date:. Once the user selects the Month, the date should dynamically show 31, 30... days based on the month chosen. Eg. 31 for January, 28 for February and so on. I got the code...

Hey! I have 2 drop-down menus. The first is called selList1 which displays the month. The 2nd drop-down menu is called destList which should display the days according to the month chosen. So if user selects January in the 1st drop-down menu then in the seconds it should display 1,2,3,4---upto...

Heres my code that displays a drop-down menu with Month: and Day:. I want that when user chooses January, it displays 31 days in the days drop-down and for april or june 30 days. However it displays only 30 days for all months--any clue whats wrong???? <form method=POST action=Time.asp...

Hi! I want to update a TimeStamp field in my database to this format:-5/11/2005 10:00:00 AM. So in my ASP code I have the following form. It produces an input box where the time has to be entered and the AM/Pm has to be selected froma drop-down menu. ***************************************...

Hi! I am creating a time management system whereby the administrator can go in and UPDATE an existing Timestamp field with a new time. I have the administrator input the date and time in a textbox. Any clue how he can update the field with this new data??? The table TimeTable has columns like...

Hi! I am building a timesheet application where the administrator should be able to login and be able to enter a time if someone has forgotten to logout. So I have having an inpur field where the administrator could fill in the time. Is there a way to have a particular format (eg. 12:30:28) so...

Hi! Here's the code I wrote to pass radio button value to another page however it does not pass any value. Any clues?? *********************MAIN CODE********************** <td width=2% class=tabletdHL2><center><input type="radio" name="radiobutton" value="<%=Computer("ComputerID")%>"></td> <td...