|
 We only get to upgrade to .Net in January. I feel so deprived... 
I've always heard that there was an idea behind Win ME... I still can't figure out what that was... anyboy know??? I;ve herad the idea was that it was supposed to be n operating system but I doubt this. - Brian Delahunty
|
|
|
|
|
I reckon I know enough of ASP.NET after 1 month crash-coursing it  But having done C# the last 6-7 months has been a real help
"There are no stupid question's, just stupid people."
|
|
|
|
|
I have this code that i use to query my database to pull out customers email addresses, however i am trying to get it to pull out email accounts from a whole list of domain names ( i.e from a comma seperated values e.g domain1.com, domain2.com )
So that i can do a bulk search and get bulk results as
domain1.com fred@somehotmail.com
domain1.com fredrika@someotherhotmail.com
---------------------------here is the current code--------------------------
<%
var-domain = Request.Querystring("domain-name")
SQL="SELECT email FROM requests WHERE domain = '" & var-domain & "'"
Set connb = server.createobject("ADODB.Connection")
connb.open "some-connection"
set user = connb.execute(SQL)
Do UNTIL user.EOF
var-email=user.Fields("email")
%>
<p><b><%-var-domain %> sdasda</b></p>
<% user.MoveNext
Loop
connb.close %>
-----------------------------------------------------------------------------------
|
|
|
|
|
This should work:
<code>
dim domain, sql, conn, adors
domain = trim(replace(Request.QueryString("domain"), "'", "''"))
sql = "SELECT email FROM requests WHERE domain = '" & domain & "'"
conn = Server.CreateObject("ADODB.Connection")
adors = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "[YourConnectionString]"
conn.Open
adors.ActiveConnection = conn
adors.Open(sql)
With Response
Do Until adors.EOF
.Write "E-Mail:" & adors("email") & " " & domain & "<br>"
.Write adors.MoveNext
Loop
End With
adors.Close
Set adors = Nothing
conn.Close
Set conn = Nothing
</code>
Nick Parker
May your glass be ever full.
May the roof over your head be always strong.
And may you be in heaven half an hour before the devil knows you’re dead. - Irish Blessing
|
|
|
|
|
Are there any standards about say when an asp page containing form submitted and I want to retrive form field values from the submitted action?
I see request.form("some form field name") ,and request.querystring("some form field name"),and even request("some form field name");Any differences?
I am not a much skilled asp programmer.So anyone please say some to me.
Thanks.
this is my signature for forums quoted from shog*9:
I can't help but feel, somewhere deep within that withered, bitter, scheming person, there is a small child, frightened, looking a way out.
|
|
|
|
|
Here you go.
If you are parsing query string, just replace request.form with request.querystring.
sub EnumForm()
dim theKey
for each theKey in Request.Form
response.write theKey & " -- " & Request.Form(theKey) & "<BR>"
next
end sub
|
|
|
|
|
Thanks.
So what is the difference between "query sting" and "form field string"?
And what is the meaning of "request("some form field name")"?
this is my signature for forums quoted from shog*9:
I can't help but feel, somewhere deep within that withered, bitter, scheming person, there is a small child, frightened, looking a way out.
|
|
|
|
|
If your form has method="get", or no method defined, the values will be passed in the query-string - e.g. http://www.yourdomain.com/page.asp?Field1=Value&Field2=Another%20Value. To access them, you need to use Request.QueryString. The amount of data you can accept is extremely limited, and will be visible in the browser history, so this method is not recommended for long forms.
If you have a form with method="post", the form values will be passed in the body of the request, and you will access them using Request.Form.
Code which calls Request("some form field name") allows for values to be passed in through either method. However, this will check all server collections (ServerVariables, Cookies, etc.) which is much less efficient than checking the correct collection.
|
|
|
|
|
Thanks,Richard.
The info is much understandable.
But I still has some puzzles.
you said "If your form has method="get", or no method defined".
What about no form defined?Can I use the http example you gave and retrieve field1 and field2 values using request.querysting("field")?
And you said "The amount of data you can accept is extremely limited",what is the limitation?
Thanks again.
this is my signature for forums quoted from shog*9:
I can't help but feel, somewhere deep within that withered, bitter, scheming person, there is a small child, frightened, looking a way out.
|
|
|
|
|
zhoujun wrote:
What about no form defined?
You can pass data to another page in the querystring without using a form. Just append the names and values to the URL, e.g. http://www.codeproject.com/script/comments/forums.asp?msg=321406&forumid=1640[^]. You need to make sure that the names and values are properly encoded, using the Server.UrlEncode method, otherwise some browsers will not process the request properly.
zhoujun wrote:
what is the limitation?
The limit is typically 2Kb.
|
|
|
|
|
Could someone please show me how to set up 2000 server to use the somename.yourdotcom.com. Thank you
Darroll
|
|
|
|
|
You need to create on your DNS the "A" (alias) record for "somename" on the domain "yourdotcom.com".
lazy isn't my middle name.. its my first.. people just keep calling me Mel cause that's what they put on my drivers license. - Mel Feik
|
|
|
|
|
Alias, once I looked that up on the web I got about a million hits. Thanks. Sometimes knowing the right terminology pays off ten fold.
Darroll
|
|
|
|
|
If its only the local machine such as my case, you can just edit the HOSTS file and map host.domain.com to your IP. I use this to access my PC via a dynamic DNS hostname, took months to realise it
"There are no stupid question's, just stupid people."
|
|
|
|
|
Hi,
is it possible to read a file (on the server) with JavaScript and embed it to the current HTML file? SSI for JavaScript? Or even better, read the file into a string or array?
-Dominik
|
|
|
|
|
Very easy indeed! Although its not embedded, the JavaScript is available on each page you add the following between the HEAD tags:
<script language="javascript" src="scripts.js"></script>
"There are no stupid question's, just stupid people."
|
|
|
|
|
No no, i don't want to include another JavaScript file.
I want to read and parse a txt-database-file...
-Dominik
|
|
|
|
|
If memory serves me correctly...theres actually an article on here that shows how to use the FSO(file system object) activeX object, which will let you read files of the client machine (i think).
As far as server side...i'm thinking your gonna have to use PHP/Perl or something to accomplish that...
Perhaps you can use the FSO for server side to, i dunno!
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
Hockey wrote:
Perhaps you can use the FSO for server side to, i dunno!
Yes, FSO is just a DLL and can be used by whatever supports it. e.g. VBScript in ASP.
Frankly using FSO client side probably is not the best idea (won't work on Mac or Linux) but use it on server side and the client can be whatever.
Paul Watson
Bluegrass
Cape Town, South Africa
Ray Cassick wrote:
Well I am not female, not gay and I am not Paul Watson
|
|
|
|
|
Paul Watson wrote:
Yes, FSO is just a DLL
Yes...I believe its a COM DLL...
Paul Watson wrote:
Frankly using FSO client side probably is not the best idea (won't work on Mac or Linux) but use it on server side and the client can be whatever
True...unless those OPS have have COM support(i think) (which i thought was growing in popularity, until .NET arrived i guess).
However at the same time...FSO I don't think will work on any server other than windows either....sure it's no probablem to the client when visting your site...but you as the host will pay twice the amount in server fee's, thats my biggest gripe...I HATE THAT!!!
Really it a no win situation, unless you have it client side and it's on a corporate website using an entranet or whatever there called...LAN instead of WAN...??? I dunno i've confused myself now... 
PHP is the way to go... IMO
Cheers!
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
Hockey wrote:
PHP is the way to go... IMO
You obviously have not tried ASP.NET
Paul Watson
Bluegrass
Cape Town, South Africa
Ray Cassick wrote:
Well I am not female, not gay and I am not Paul Watson
|
|
|
|
|
Nope, but I have tried ASP and I didn't like it all that much, other than it's easy to get things rolling.
It's my understanding you have to purchase (most of the time) COM components in order to do anything really interesting...like sendmail or FTP, generate images or PDF docs, which are always out of my budget...
PHP is cheaper, probably faster to execute and most servers include all the neat libs like zlib(compression thingy???), pdf generation and such...
Unless ASP.NET offers all these advanctages i'm not sold on ASP.NET...just yet...
I really hate the fact ASP hosting is twice the price...tis why I chose PHP instead...sure theirs chilliASP, but i've heard it really sux...so I dunno if my assumptions are correct, but i'll do without...
Cheers! 
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
Hockey wrote:
Unless ASP.NET offers all these advanctages i'm not sold on ASP.NET...just yet...
ASP.NET has all of the .NET framework and any COM or .NET components that you can think of at it's disposal. It's really cool. You should try it out a bit. 
You will now find yourself in a wonderous, magical place, filled with talking gnomes, mythical squirrels, and, almost as an afterthought, your bookmarks
-Shog9 teaching Mel Feik how to bookmark
I don't know whether it's just the light but I swear the database server gives me dirty looks everytime I wander past.
-Chris Maunder
|
|
|
|
|
David Stone wrote:
ASP.NET has all of the .NET framework and any COM or .NET components that you can think of at it's disposal. It's really cool. You should try it out a bit
Perhaps, but I can probably do just about everything ASP.NET can do in PHP...and i'm supporting the open source market...
PHP is way the hell cheaper too, which is always nice...
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
Hockey wrote:
It's my understanding you have to purchase (most of the time) COM components in order to do anything really interesting...like sendmail or FTP, generate images or PDF docs, which are always out of my budget...
First off ASP.NET is as far removed from ASP as procedural programming is from OOP. It really is a vastly different beast.
With the .NET Framework you get virtually all the components you could wish for. Upload, FTP, image manipulation, email etc. For PDF generation you can just use XSL-FO and the .NET XML classes.
Also all the "components" work the same way and are within the framework so no having to figure out new things when you get a new component, quite handy that.
Hockey wrote:
PHP is cheaper, probably faster to execute
ASP.NET is free as it is part of the .NET Framework. Though I will admit PHP beats ASP.NET on the licensening front, but then 99% of us never need to make our own redistributable of PHP, so that licensecing advantage is hardly ever used.
I will bet that ASP.NET is faster than PHP now. ASP was the dogs bollocks, but ASP.NET is a fully compiled environment now (well as fully compiled as .NET stuff can be.)
All in all PHP is going to need to do something pretty revolutionary (as ASP.NET is to ASP) for it to keep pace with ASP.NET.
But then from the sounds of it your situation is better served by PHP. My situation involves clients who are willing to pay for ASP.NET hosting and we have our own hosting server anyway.
So I could talk your ear off about ASP.NET, supermodels and bra-fitting, but it would not do much good.
If you are ever in a better hosting situation though, give ASP.NET a look. There are free dev tools out there now, the .NET Framework is free and the whole environment is just so much better than ASP.
Paul Watson
Bluegrass
Cape Town, South Africa
Ray Cassick wrote:
Well I am not female, not gay and I am not Paul Watson
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
