|
I've found the following example.
Hope it helps you
Michela
<%
conn.Open strconnection
set rs = conn.OpenSchema(maxTable) ' maxTable=20 for me
%>
<%
do while not rs.eof
if rs("table_type") = "TABLE" then
%>
<%
end if
rs.movenext
loop
rs.close
%>
» | Tables
| | Table Name | | <%=rs("table_name")%> |
|
|
|
|
|
Thanks....
Will give a try on it!!
I was born intelligent Education ruined me!.
|
|
|
|
|
I have created a simple C# ASP.NET app, that uses a database(SQL) which is programed only to check users againsit a the database entry. when I try to run the program, I get to the server page, and than when I enter the user password, than I press invoke. however I just get a "The page can not be displayed - There is a problem with the page you are trying to reach and it cannot be displayed." error message. To my knowledge I have programmed this correctly, but can't seem to get pass this error. The below code is all I'm doing:
[WebService(Name="TestWebServer Web Service", Description="Test SQL Database")]
public class Service1 : System.Web.Services.WebService
{
const string connStr="server=SILICON;uid=sa;pwd=;database=MytestDatabase";
[WebMethod(Description="Method to Authenticate Users")]
public bool Authenticate(string username, string password)
{
SqlConnection dbConn = new SqlConnection(connStr);
string sqlStr = "SELECT Password from PM_USERS where UserName = '" + username + "';";
dbConn.Open();
SqlCommand dbCommand = new SqlCommand(sqlStr,dbConn);
SqlDataReader dbReader = dbCommand.ExecuteReader();
bool returnBool;
if (dbReader.Read())
{
if (dbReader[0].ToString()==password)
{
returnBool = true;
}
else
{
returnBool = false;
}
}
else
{
returnBool=false;
}
dbReader.Close();
dbConn.Close();
return returnBool;
}
that's pretty much it!
|
|
|
|
|
|
Ooops, I did mean webservice! tried the debugger, still trying!!
|
|
|
|
|
|
I want to extract the title of the web page that I am in... Any option for this... Example code will help me a lot!!
I was born intelligent Education ruined me!.
|
|
|
|
|
what tool do you use?
vbs or ..?
|
|
|
|
|
I run my site with the ASP pages... and javascript are prefered...
I was born intelligent Education ruined me!.
|
|
|
|
|
|
so simple as this....
Perica Zivkovic wrote:
alert(document.title)
It works.... How did I missed this????
I was born intelligent Education ruined me!.
|
|
|
|
|
Hi..
use the Document object's title property .. this example is a html
file with a button.. click it to see a messagebox that shows the title
of the document..
I had to use VBScript not javascript because I don't use it..
<title>MyTitle
function OnBtnClick
MsgBox document.title
end function
|
|
|
|
|
I got it... Thanks!
I was born intelligent Education ruined me!.
|
|
|
|
|
There are many websites offering advt campaign. There.. they say that the charge is per XXX impresssions. Just displaying the advt for XXX times. How is this calculated and the XXX times is achieved??
I just wanted to know the method a person can implement in the site??
I was born intelligent Education ruined me!.
|
|
|
|
|
We have an application which consists of a SOAP Web Service and a client of the service, which runs as a NT service.
This works well with http, but does not with https. There is no problem if we use IE to query the Web Service in https, but the SOAP client cannot.
We noticed that the SOAP client is not even trying to initiate the TCP connection (SYN), as if it was trying to do something SLL-related prior to open the actual socket.
The connection works on most environments, except on ones where the security has been harnessed (correct wording?).
Anybody has any idea of what is wrong?
|
|
|
|
|
Is client authentication required?
If so, the SOAP client may lack a valid certificate.
If not, the client may be unable to load the CA-chain and thus is unable to verify the server.
More information is required to be more precise.
"You can stand all night at a redlight anywhere in town, hailing Marys left and right but none of them slow down. I've seen the best of men go past. I don't wanna be the last..."
|
|
|
|
|
Maybe you misread:
We noticed that the SOAP client is not even trying to initiate the TCP connection (SYN), as if it was trying to do something SLL-related prior to open the actual socket.
So the client does not even have the chance to get the certificate, because it is not even able to perform the TCP SYN (like it is not trying to open the socket). If we use regular HTTP, everything works fine.
|
|
|
|
|
Misread? Me? Nah, never
Disclaimer: Haven't done any serious SSL programming for a couple of years...
What I was talking about is that you can specify before opening the connection that server authentication is required.
If so, if no CA-chain has been loaded there is no point in trying to open the connection since the server can't be authenticated anyway.
Clientside authentication shouldn't be a problem since if I remeber correctly, the server will ask for the certificate if needed (configured).
The configured ciphersuite shouldn't be a problem either since that is handled during the handshake.
TIP: Go to www.openssl.org[^], download and compile. Try connection with the SSL tools, they are pretty neat (a bit hard to use the first time though).
"You can stand all night at a redlight anywhere in town, hailing Marys left and right but none of them slow down. I've seen the best of men go past. I don't wanna be the last..."
|
|
|
|
|
In fact, workaround found. We changed the client to use the CSoapWininetClient instead of CSoapSocketClientT .
We found a workaround, but we still don't know why we add the errors with the first class. Missing step?
|
|
|
|
|
Hello,
This isn't a development problem but someone may have experienced something similar ...
I recently signed up for another ISP and I've been experiencing a strange problem.
Every so often, usually after reading an email that contains web content, I get a pop-up dialog that looks like this:
It is a dialog box titled "Dial-Up Networking."
It contains 3 buttons
"Yes, dial", "No, do not dial = 11", "Settings >>"
The second button counts down in seconds until the dialog disappears.
Then it shows a drop down
Dialing from "New Location"
Then two check boxes
Disable auto-dial for this logon session
Always prompt before auto-dialing
It then disappears after a few seconds and then reappears until I select "Disable auto-dial for this logon session"
I have several other internet connections and I wasn't experiencing this behaviour prior to installing a new ISP. Has something been installed or congfigured behind the scenes?
My set-up is:
Windows NT 4 Service Pack 3
IE 5.5 (without service pack)
Outlook Express 5.5
Kevin
|
|
|
|
|
i have a page (ChangePreferences.asp), which is accessed via a link on Page1.asp. ChangePreferences.asp can also be accessed from links on other pages. Having processed the information received from ChangePreferences.asp, how do i redirect back to the page from which it was accessed? (ie it could have come from page1.asp or page2.asp etc). could i use something like Session("lastpage") and redirect back to that? Thank you!
|
|
|
|
|
The easiest way to do this is to put the referring page in the querystring when you link to ChangePreferences.asp, i.e. page1.asp might have this:
<a href="ChangePreferences.asp?redir=page1.asp">Blah</a>
then in ChangePreferences.asp (I'm assuming you have a form which is submitted on this page and then you want to redirect)
make sure you persist the redir value, either by appending it to the form action (e.g. <form action="ChangePreferences.asp?redir=<%=request.querystring("redir")%>", or by adding it as a hidden input.
then once you've done the processing simply do either:
Response.Redirect (Request.Form("redir"))
or
Response.Redirect (Request.QueryString("redir"))
depending on how you maintained the value of redir.
HTH
|
|
|
|
|
i have a page which allows a user to change their colour preferences. Having chosen from radio buttons, the information is submitted to a ChangingColour page which processes the information using the following code:
<% Option Explicit
If Request.Form("Remember") = "rem" then
Response.Cookies("Colour") = Request.Form("Colour")
Response.Cookies("Colour").Expires = "31 Dec, 2003"
Elseif Request.Form("Remember") <> "rem" then
Response.Cookies("Colour") = Request.Form("Colour")
Response.Cookies("Colour").Expires = Now + 30
End if
dim Last
Last = Session("LastPage")
Response.Redirect Last
%>
However, it is not alone changing the colour permanently (as it should) but it is not even changing it for the session. What am i doing wrong??! Thank you!
|
|
|
|
|
Hi this is a little OT
My problem best fits in this discussion board though.
Basically I have wget'ed a site. Say www.mysite.com and riddled all through it is HREF references such as www.mysite.com/part2.htm. Now that I have the whole site locally I would like to be able to view each bit without having to be on the net. So the question is there a HTML that will do the right thing and recursively strip the root URL out of the correct places and leave the references intact. I suppose you could use sed or perl but I was wondering if there was some tool that would do it a bit neater. e.g I suspect other tools might blindly strip some URLS out when that is not wanted.
Thankyou,
Tom.
|
|
|
|
|
anonymous wrote:
Now that I have the whole site locally I would like to be able to view each bit without having to be on the net
Isn't that the purpose of a web ripper ?
anonymous wrote:
I would like to be able to view each bit without having to be on the net
Offline mode does not work ? As long as your site is known by IE (is in the cache), it solves urls even if they point to web sites.
|
|
|
|