Hi
pls chk the foll query :
first create #temptable and then execute the below query with the specific coloumn name
insert #temptable(userid)select userid from table1 union select userid from table2
this will copy distinct records from table1 and table2. No duplicates.
HS :) *** ASP/VB/SQL...
Hi
pls chk the foll query :
first create #temptable and then execute the below query with the specific coloumn name
insert #temptable(userid)select userid from table1 union select userid from table2
this will copy distinct records from table1 and table2. No duplicates. *** ASP/VB/SQL...
Hi
The code for the drop-down should be something like this :
<SELECT>
<OPTION VALUE="" SELECTED></OPTION>
<%do while not rs.eof%>
<OPTION VALUE="<%=rs(0)%>" SELECTED><%=rs(0)%></OPTION>
<%rs.movenext
loop%>
</SELECT>
Hope this solves your problem :) *** ASP/VB/SQL...
Hi
There seems to be some path problem in that objMyMail.AttachFile(Request.Form("mailattachment")) statement. Please check the file path if its rsiding on ther server and give the actual path.
:) *** ASP/VB/SQL Programmer (Free Lancing work accepted) *** B-)
Hi
I do not think there is any problem with the code. But hey u can try this out :
Set mymail=Server.CreateObject("CDONTS.NewMail")
mymail.BodyFormat=0
mymail.MailFormat=0
mymail.To="abc@yahoo.com"
mymail.From="abc@hotmail.com"
mymail.Subject ="Hello"...
Hi
I would like to know a few things about include files :
1. Can we include a file from a different server?
2. If i have 15 include files on an asp page, will the page speed be faster if compared to the page with 0 include files(i would paste the code from those files onto my asp page)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.