|
Also ensure all the correct headers are included
ie:
From
Reply-To
Content-Type
mime-version
eg:
$headers = "From: Sender<sender@yourdomain.com>\r\nReply-To: sender@yourdomain.com";
//add boundary string and mime type specification
$headers .= "\r\nContent-Type: text/html;"."MIME-Version: 1.0";
|
|
|
|
|
I have created a stored procedure in SQL Server 2005. I am trying to call that procedure from ASP (Classic asp) page. The stored procedure returns a recordset of this query.
SELECT Count(worklist_P.wrkID) AS Total, Sum(CASE WHEN complited = 'True' then 1 else 0 end) AS [comp],
Sum(Case when readed = 'False' then 1 else 0 end) AS new,
Sum(Case When complited = 'False' then 1 else 0 end) AS pend
FROM (employee_Master INNER JOIN worklist_C ON employee_Master.empID = worklist_C.assignedWhom)
INNER JOIN worklist_P ON worklist_C.wrkID = worklist_P.wrkID WHERE (((worklist_C.assignedWhom)=@empId));
I am calling that procedure in following code:
set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = con
cmd.CommandText = "wrksCnt"
cmd.CommandText = "{call wrksCnt(?)}"
cmd.Parameters.Append cmd.CreateParameter("@empId", 3, 1)
cmd.Parameters("@empId") = 2
set rsWork = cmd.Execute()
But it is not returning anything. I have tried executing above stored procedure in SQL Server 2005. It is running well. Giving proper output.
I have also tried this code to
strSql = "exec wrksCnt '" & Session("empID") & "'"
set rsWork = con.Execute(strSql)
This code is also not returning any value. Please guide how to call stored procedure properly in classic asp page.
Kiran Sajanikar
Software Engineer
Pune, India
|
|
|
|
|
you asked the same question, 3 posts down, I gave you a link, then you decided to delete your message and post it again. Sorry, that will not help.
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
I have gone through your reply. I found that I have alredy refferd that link before starting this thread. I have imergency for the solution. Thats why I did so. I extrimly sorry for that.
But now could you please go through my post again and help me out detecting my bug to solve my problem.
Kiran Sajanikar
Software Engineer
Pune, India
|
|
|
|
|
I have tried above code with different query. The recordset is returning -1 recordcount.
I have tested both queries in Sql Sever 2005, They are running well and giving proper output.
Then why the recordset is returning me -1 recordcount.
New query is as below :
strSql = "SELECT TOP (50) MAX(feedback.replyID) AS replyID, feedback.wrkID, MAX(feedback.feedback) AS feedback, MAX(employee_Master.empName) AS empName, " & _
"MAX(feedback.replydate) AS replydate, feedback.empID, worklist_C.complited " & _
"FROM employee_Master INNER JOIN " & _
"worklist_P INNER JOIN " & _
"feedback ON worklist_P.wrkID = feedback.wrkID ON employee_Master.empID = feedback.empID INNER JOIN " & _
"worklist_C ON worklist_P.wrkID = worklist_C.wrkID AND employee_Master.empID = worklist_C.assignedWhom " & _
"WHERE (worklist_P.assigedby = 2) " & _
"GROUP BY feedback.wrkID, feedback.empID, worklist_C.complited " & _
"HAVING (feedback.empID <> " & Session("empID") & ") " & _
"ORDER BY replyID DESC, replydate DESC"
set rsReply = Server.CreateObject("ADODB.Recordset")
rsReply.Open strSql, con, 1, 3, 1
Kiran Sajanikar
Software Engineer
Pune, India
modified on Thursday, April 2, 2009 12:45 AM
|
|
|
|
|
I have tried simple stored procedures to return recordset
like : Select * From
It is running good, giving proper out put.
But If I am making it bit complicated then recordset is returning -1 recordcount
e.g. : Select Count(bId) from bTable
This stored procedure is running well in SQL Server 2005, but if I am caling them in ASP pages it is returning me -1 recordcount.
Please Help me
Kiran Sajanikar
modified on Thursday, April 2, 2009 12:46 AM
|
|
|
|
|
I got stuck with above issue.
I am not getting any answer to it.
Please help me.
Kiran Sajanikar
|
|
|
|
|
Dear all,
I have been trying to find a way to put a small toolstrip (much like the one on facebook) at the very bottom of my page and make it stick there.
I've made use of screen.height, screen.availHeight to, well, no avail. It keeps being cropped or goes off the screen or appears too high up.
Is position:absolute the right way to go?
Do i need to calculate the actual position in the y-axis subtracting the height of all the other controls on my page?
I'm really stuck, and it's the control that should stick, not me.
I'm sorry if that question has already been asked, I am not even sure what keywords to use to look for the solution.
Regards,
Greg
var question = (_2b || !(_2b));
|
|
|
|
|
|
you're wanting "position:fixed"
|
|
|
|
|
Hello Friends
I am conducting a survey on e-learning. Please participate in this survey at following URL:
www.rpgwebsolutions.com/online_survey/main.asp
Please help me in collecting data.
Thanks
Poonam
|
|
|
|
|
So, why do you need the user to enter his/her name and mail-address?
|
|
|
|
|
|
|
hi can any body to help me how to make webdesign i want to make website but i did not know how to make style .
the web for org i want style have submenu and tow cloum and gridview
|
|
|
|
|
|
Hi..
I have uploaded my website in ftp.
When I browse my website, I am getting Err Msg in browser as follows
This Virtual Directory Does Not Allow Contents To Be Listed.
Could u please tell me what is happening, I really got tired after so much trial and error.
And tell me what is the relation between my virtual directory in loacal machine and my website which is there in ftp...
Please do me this favour...
Awaiting..\
Hemant
By:
Hemant Thaker
|
|
|
|
|
You didn't give many details, so this is just a guess.
The web server you are using (such as Apache or IIS) does not allow directory listing for the specific path you typed in. For example, suppose you have this URL:
http://mysite.com/coolsite/
Normally, when your browser asks for that folder from the web server, the server looks for a default page in that folder. You can configure what a default page is, but the most common are like these:
index.html
index.htm
default.html
default.htm
In case there is no default file that matches, a web server will check its settings to see if it has permission to give a directory listing.
Usually this is set to no, because that can give too much information to hackers. But the web site administrator can choose to allow directory listings for the whole site or just for certain folders.
Your problem seems to be that.
Don't let my name fool you. That's my job.
|
|
|
|
|
Hi..
Thanks for ur immediate reply...
I developed the website in asp.net and my startup page is "InserPayDetails.aspx".
And i want this page to be displayed , when i browse my site.
Normally what i do is... go to ftp and put the whole content in wwwroot directory...
so is it enough, or i need to do something more than this..
thanks
Hemant
By:
Hemant Thaker
|
|
|
|
|
It appears your web server is running MS IIS.
If you have a web server administrator, ask him. I guess you do not, so...
If you have direct access to that computer, open the IIS console application and check the defaults for your particular case. Rename your startup page to the correct version (like index.aspx). However, you may not want to change the name, so...
Add your page name exactly as is to the list of defaults. But just in case you don't have access to the IIS computer...
Just navigate directly to that page, such as:
http://mysite.com/somepath/InserPayDetails.aspx
It's best to have a default page of some sort, because most people will not want to type the full path. You could make up one that has a link to the intended startup page, or that automatically redirects. There are lots of things that could be done. Good luck.
Don't let my name fool you. That's my job.
|
|
|
|
|
Hi...
Now what i did was i renamed my startup page from anything.aspx to index.html and now if i browse my website i am getting index.html , but other pages are .aspx and for them i have put links in this .html page.
Now i m getting startup page but can not browse the .aspx pages
please guide for this
thanks
Hemant Thaker
By:
Hemant Thaker
|
|
|
|
|
The ASPX tells the server it needs to be handled as a MS ASP special file, which means it pre-processes the file before sending it to the client.
HTML tells the server to just send it as is to the client.
And you can't choose any old extension, because each one has its own rules. Your page is ASPX type, so it must have that extension.
Every folder (also called directory) can have different default pages. You have to find out what ones are defined for your folder. This means you have to run the IIS administration program (I don't know the name, but it's probably in Control Panel on the web server) and see what's available.
If ASPX is not available, you'll have to add it.
It sounds like you have a lot of learning to do. Maybe find an ASPX for Beginners tutorial or something.
Don't let my name fool you. That's my job.
|
|
|
|
|
we can change default page for the website by adding the particular page to website properties "Documents" tab in IIS 6.
I assume that you do not have access to website properties "Documents" tab.
Best to change page to "default.aspx"
which will be default when you install .net in IIS.
Hope u understand.
|
|
|
|
|
protected void Sndbtn_Click(object sender, ImageClickEventArgs e)
{
SmtpClient serverobj = new SmtpClient();
serverobj.Credentials = new NetworkCredential(Frmtxt.Text, Pswtxt.Text);
serverobj.Host = "smtp.gmail.com";
Totxt.Text = "gayatri.subudhi@gmail.com";
serverobj.Port = 587;
serverobj.EnableSsl = true;
msgobj = new MailMessage();
msgobj.From = new MailAddress(Frmtxt.Text , "gai3", System.Text.Encoding.UTF8);
msgobj.To.Add(Totxt.Text);
msgobj.Subject = Subtxt.Text;
msgobj.Body = Messtxt.Text;
msgobj.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
msgobj.IsBodyHtml = true;
serverobj.Send(msgobj);
Lbl.Text = "MAIL SENT SUCCESSFULLY.......!";
}
this code will work for gmail messageing..but ineed
I need to mail for all type of IDS like yahoo,gmail ,reddiff etc. what will the port no. and server host will used..
and another one without giving password ,by giving email id how to sent mess to administration.please suggest me.Thanks in advance.
With Regards
Ch.Gayatri Subudhi
|
|
|
|
|
Use the instructions they all give to allow people to use Outlook.
Yahoo![^]
Rediff[^]
hmmm pie
|
|
|
|