Good Day
Just wanted to ask for any help on how could I count a record depending on the value of the two column. Example below table i need to count the productivity of the agent for march 1 for each telno and for march 2 for each number.
the rule is 1 productivity per telno per day. Even they encoded many data for same telno still it count 1.
SQL = SELECT ACTION_DATE, COUNT(DISTINCT ACTION_RECNO) FROM WEB_ACTIONDETAI LSDONE...
rjlorenzo
Last Activity: Mar 31 '10, 05:15 AM
Joined: Oct 7 '08
Location:
-
Yes I'am using a next/previous button. how i could use a session on this. can i have an basic example please.
thank you very much and more power.
RJ Lorenzo -
retain value of radio button on the next page or previous page
Hi to all,
I have created a survey page that consists of 4 pages 10 question on each page. Each question are just answer using a radio button. Now my problem is i have to retain all the answer/value of radio button even the user click previous page then going back to current page. appreciate any idea please.
thank you in advance -
asp connection to SQL server DB
Good Day,
Just want to ask some help please, currently I'm using MS Access as my database but now I would like to use SQL DB as my database. Could anyone help me how to convert my connection string from ms access to sql db. below is my connection on ms access please do modification to work it on SQL. Many thanks in advance.
...Code:<% dim strConn strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&
-
Hi thanks you for reply, still didn't recieved the mail and no error message or successful message display. see my complete code below.
...Code:if grp <> act_stage then Dim myMail Set myMail=CreateObject("CDO.Message") myMail.Subject = "testing auto email" myMail.From = "ab@xxx.com.ph" myMail.To = "cd@xxx.com.ph"Last edited by Frinavale; Oct 15 '09, 03:13 PM. Reason: Please post code in [code] ... [/code] tags. Added code tags.Leave a comment:
-
Hi in additon i did this but the problem is i did not received the email. please help. thanks
Code:Dim myMail Set myMail=CreateObject("CDO.Message") myMail.Subject="Sending email with E2E" myMail.From="mymail1@ab.com.ph" myMail.To="mymail@ab.com.ph" myMail.TextBody="This is a message." myMail.Send set myMail=nothingLast edited by Frinavale; Oct 15 '09, 03:13 PM. Reason: Please post code in [code] ... [/code] tags. Added code tags.Leave a comment:
-
How to auto send an email using asp classic.
Hi Everyone,
I'm just a beginner on asp, just want to ask for the help on how I could do to have a auto email send on my program. Just please give me some basic codes like if the user click OK then it will automatic send a email to specific email address with subject "thank you" and body text "please reply"
thank you in advance for the help
RJ -
displayed data using radio button
Good Day,
I just need help on my programming. I would like to try to retrieved/edit the data i've save using radio button and want it to displayed on radio button for editing or changing the choices.
For example i have 2 radio buttone voice and data. when is save on the database the value of checked button is "1". Then when the use want to change their choices I want to display this radio button that the one... -
page cannot be displayed on windows server2003
Good Day,
I have a problem on my server 2003, when i tried to search the whole data or large data, i got page cannot be displayed but when i tried to installed/setup my asp program on winxp with IIS its work fine. is ther any settings or configuration i need to do on windows server 2003?
NOTE: in windows server 2003, when i tried to search and displaye a small data to display it works but when it reach around 10,000 record... -
Using both AND OR on the query
Good Day,
I'm trying to display record using a query below.
What...Code:if sagent = "CARE" AND FDATE <>"" AND TDATE <>"" then SQL = "SELECT * FROM WEB_PRODUCTIVITYDONE WHERE PROD_USER ='lckatigbak' OR PROD_USER ='jbmarquez' AND PROD_ENTERED BETWEEN #" & fdate & "# and #" & tdate & "#;" end if
-
putting a simple pop up calendar
Good Day,
Need your help guys, right now i have a text box where they enter the date with format mm/dd/yyy. Instead mo this i just wnat to put a pop up calendar. when the user click the "Date From" then the pop up calendar will appear and after the user select the date, on the text box it will show the date. Please help me i just need a simple calendar.
thank you in advance. -
Thank you friend, Its work very well now.
Your the Man!
God Bless to AllLeave a comment:
-
thank you very much to all, i'm now able to run the query, see below.
SQL = "SELECT * FROM WEB_PRODUCTIVIT YDONE WHERE PROD_USER like '%" & sagent & "%' AND PROD_ENTERED between #" & fdate & "# and #" & tdate & "#;"
the problem now is for example, i entered aug 1, 2008 and aug 3, 2008 then it only show the data for aug 1 and aug 2. what i need is to displayed...Leave a comment:
-
thank for the help but still i got and error.
Error Type:
Microsoft VBScript compilation (0x800A0408)
Invalid character
/prs/search_details. asp, line 91, column 20
SQL = String.Format(“ SELECT * FROM WEB_PRODUCTIVIT YDONE WHERE PROD_USER like '%{0}%’ AND PROD_ENTERED BETWEEN '%{1}%’ AND ‘%{2}%’”, sagent, fdate, tdate)
*************** ********
I really new on asp. if possible could you provide...Leave a comment:
-
may SQL is just
Dim SQL, tdate, fdate
On may access DB PROD_entered is date/time type.
How should declared the variable? please help and thank youLeave a comment:
-
displaying record between two dates errors
Good Day Everyone,
Requesting for your expertise please, in my program the user has to enter the agent name and the from date and to date inorder to display the record. I have to use 2 conditions. First look for the record with the same agent and display all record for that agent but the date should be within the two dates enter. Below are my codes, when running i got the error message invalid data type.
In my database the...
No activity results to display
Leave a comment: