Search results for query: *

try this out: select aka,sum(hits) from <your table name> group by aka order by aka

The return of Year(date), Month(date) and day(date) are most probably numeric. But Len function needs a character string for evaluation. This may be the type mismatch. Try the following: If Month(date) = 1 Then dNumTemp = dNumTemp & &quot;0&quot; & Month(date) Else dNumTemp...

You can definitely do this by ASP. Let's look at it step by step. 1. Make the form send the form data to the ASP file This is easy. While declaring the form by <form> tag, give action=&quot;savetodb.asp&quot; as the target file. You can submit data is two ways... method=post will submit the...

Change the instring function as below: INSTR(fvalue,&quot;-&quot;) Then it will return the number of times &quot;-&quot; apprears in the string. I think, this will solve the problem. Shihab

In ASP you can use FormatNumber function to format your numbers, as below: <% For i = 0 to RS.Fields.Count - 1 %> <TD VALIGN=TOP> <% RESPONSE.WRITE FormatNumber(RS(i).VALUE) %> </TD> <% Next %> The rest should be okay. In general the formatting will be as below: FormatNumber(1234567) -->...

Hi, We are forwarding emails using the /etc/aliases file. You can of course keep a copy also. For example, any mail to Peter need to be forwarded to Cindy. Then you can write: peter:cindy@hotmail.com,peter, This way the mail is forwarded to Cindy, but also a copy goes to Peter. You can also...

The only way to increase security is to hide your code by using DLLs, Stored Procedures and other middle-tier functions. You may also use separate function files and call the functions from your visible ASP page. This way codes inside the functions may be hidden. I am facing a similar problem...