help with query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

help with query

Author

Topic

webproblem
Starting Member

1 Post

Posted - 2005-02-13 : 12:30:23

If anyone can help it would be great. Im new to SQL and point in the right direction would be great.

Here is my code.


<%
var to = Server.CreateObject("ADODB.Recordset");
to.ActiveConnection = MM_s4r_STRING;
to.Source = "SELECT newdate, news FROM dbo.news";
to.CursorType = 0;
to.CursorLocation = 2;
to.LockType = 1;
to.Open();
var to_numRows = 0;
%>
<---this is what i need help with. -->
<%= Server.URLEncode((to.Fields.Item("news").Value)) %>
<%= Server.URLEncode((to.Fields.Item("newdate").Value)) %>

<%
to.Close();
%>

This is the result:

A+PBX+%28

private+branch+exchange%29+is+a+telephone+system+within+an+enterprise+that+switches+calls+between+enterprise+users+on+local+lines+while+allowing+all+users+to+share+a+certain+number+of+external+phone+lines%2E+The+main+purpose+02%2E05%2E05

How do add a write function to this part of the code.
<%= Server.URLEncode((to.Fields.Item("news").Value)) %>
<%= Server.URLEncode((to.Fields.Item("newdate").Value)) %>

to make the result display in a format like this

&news=2E05%2E05

&newdate=telephone+system+within+an+enterprise+that+switches+calls+between+enterprise+users+on+local+lines+while+allowing+all+users+to+share+a+certain+number+of+external+phone+lines%2E+The+main+purpose+02%2E05%2E05

I have tried some doc.write functions but doesnt work... any help would be great thanks.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-02-13 : 12:46:02

you mean you need Response.Write("someText") method?

Go with the flow & have fun! Else fight the flow

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources