|
|
I develop a web site by ASP and SQL Server.
The connection to SQL Server is stored in the Application object : Application("Connection"). (That database connection is established in the global.asa). I use only this connection for all ASP pages. But I am so confused that what will happen if there are many pages (which are accessed from many clients) use the same connection at the same time? And can I use the Application.Lock...
Please explain me if my way is right ?
|
|
|
|
|
Don't do it that way is the simple answer.
There are two ways you should do it, based on the traffic and resources of your site.
First way is for small sites where scalability etc. is not as important and where you cannot afford to do things the second way. This is to open the connection each time you need it and then close it right after you have used it. Open late, close early.
The second way is to use a COM component which has a pool of database connections. Your ASP code then never talks directly to the database, but rather speaks to your data access layer which is in the COM component and which manages the connections. There is a very good article on pooling right here on CP (but I can't find it. Just look for database connection pooling or thereabouts.)
Application.Lock is probably a bad idea because you then have to managed it very carefully and have a transactional system. What happens if an error occurs after an Application.Lock but before the unlock? Your error handling has to be very good and really it sounds like a nightmare.
Paul Watson
Bluegrass
Cape Town, South Africa
Macbeth muttered:
I am in blood / Stepped in so far, that should I wade no more, / Returning were as tedious as go o'er
DavidW wrote:
You are totally mad. Nice.
|
|
|
|
|
Thanks so much. But please show me the risks when only one database connection was use for all pages. I'm using only one database connection for my web project but I cannot find errors...I don't know when???
Can I use the connection pooling which is provided by the ODBC 3.0 through ADO (without COM, as our ealier discussion)?
Suppose that we use the connection pooling technique and SQL Server is licensed for 5 clients (maximum 5 connections at a time), what will happen if there're more than 5 web-clients request at the same time?
|
|
|
|
|
Can anyone help to show me the best way to manage user session. I am using the Session object to store user session after user log in but I see that it not good and not stable. I am starting with ASP so that I do not have enough experience.
Thanks for any helps.
|
|
|
|
|
I would try to use cookies instead of session vars if possile. Now cookies can be a hassel too, but it is far more scalible.
Fear not my insanity, fear the mind it protects.
|
|
|
|
|
What will happen if the browser is disabled to use cookies?
|
|
|
|
|
You have to use a combination of 3 things:
- database;
- session vars;
- cookies
You can use cookies to leave some portion of the data in the users computer but for a session you wouldn't have to rely on persistent cookies. You should use per session cookies (see this option in Internet Options in IE) just to store an SID (session id) and the rest of the variables should be stored in the db. In every page you will get the sid, query the db and get all the variables you need for that session. It's even secured this way.
-----
We are what we repeatedly do. Excellence, then, is not an act, but a habit.
|
|
|
|
|
suppose i have 5 pages on my website. if i visit page2 from clicking a link on page1, how will page2 know that from which page i was called.
can anyone help me with that? plz
|
|
|
|
|
Hi,
a few ways you can do this... not sure if you wanted to do this server side or client side so here's both:
for server side (asp):
Request.ServerVariables("HTTP_REFERER")
for client side (javascript):
document.referrer
both of these will return a string which will look something like this:
http://servername/page1.html
HTH
|
|
|
|
|
I am building a site for a DVD rental company and I am wanting to have entertainment news stories (like a mini-blog) on my front page with a short blurb, the date, and a link. Does anyone know of any entertainment news web services? I would prefer a free one, but let me know of any that you would recommend even if they cost money. I can just write a web client and parse a page using regex, but it's harder that way and destined to fail as soon as the news web site I'm pulling from changes.
Any suggestions?
-Matt
------------------------------------------
The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall
|
|
|
|
|
Hello all,
I have text as multiple lines in a RichTextBox in my application. How can I programmatically bullet them ?
Thanks
Smitha
The future belongs to those who believe in the beauty of their dreams.
--Eleanor Roosevelt
|
|
|
|
|
You need to send mail in a free hosting that does not support mail object (like free account of brinkster)this is a solution:
Try my demo:
http://www25.brinkster.com/vokha/mail.asp
This is my code(This code using CDOSYS to send mail):
<%
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'Source code send mail in anyhost that support ASP and run below Windows 2000
'This source code send mail using a remote SMTP server that support open relay
'If you can't send mail in any server by this code. Please contact me. Because I using another
'server to send mail. So if someone change my password. It doesn't work. To make it work you
'should go to http://online.ie/registration/index.adp (Or any SMTP Server that support open relay). Register an account
'and place your username and password in the following code
'
' objConfig.Fields(cdoSMTPServer) = "Your server"
' objConfig.fields(cdoSendUserName) = "Your account"
' objConfig.fields(cdoSendPassword) = "Your password"
'
'Written by: VO KHA
'Email: one_puppy@yahoo.com
'Website: http://www.qitt.com, http://www.qitt.com/forum/
'Referce: msdn.microsoft.com, file cdosys.idl
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
if(trim(Request.Form("btnSend")) <> "") then
Dim strFrom, strTo, strSubject, strBody
strFrom = trim(Request.Form("txtFrom"))
strTo = trim(Request.Form("txtTo"))
strSubject = trim(Request.Form("txtSubject"))
strBody = trim(Request.Form("txtContent"))
call CDOSYSSendMail(strFrom, strTo, strSubject, strBody)
end if
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
function CDOSYSSendMail(strFrom, strTo, strSubject, strBody)
Const cdoSendUsingPort = 2
Const cdoSendUsingMethod = "http://schemas.microsoft.com/cdo/configuration/sendusing"
Const cdoSMTPServer = "http://schemas.microsoft.com/cdo/configuration/smtpserver"
Const cdoSMTPServerPort = "http://schemas.microsoft.com/cdo/configuration/smtpserverport"
Const cdoSMTPAuthenticate = "http://schemas.microsoft.com/cdo/configuration/smtpauthenticate"
Const cdoBasic = 1
Const cdoSendUserName = "http://schemas.microsoft.com/cdo/configuration/sendusername"
Const cdoSendPassword = "http://schemas.microsoft.com/cdo/configuration/sendpassword"
Dim objMessage, objConfig
Set objMessage = CreateObject("CDO.Message")
Set objConfig = CreateObject("CDO.Configuration")
objConfig.Fields(cdoSendUsingMethod) = cdoSendUsingPort
objConfig.Fields(cdoSMTPServer) = "mail.online.ie"
objConfig.Fields(cdoSMTPServerPort) = 25
objConfig.Fields(cdoSMTPAuthenticate) = cdoBasic
objConfig.fields(cdoSendUserName) = "one_puppy"
objConfig.fields(cdoSendPassword) = "testme"
objConfig.Fields.Update
Set objMessage.Configuration = objConfig
objMessage.To = strTo
objMessage.From = strFrom
objMessage.Subject = strSubject
objMessage.TextBody = strBody
On Error Resume Next
objMessage.Send
If Err.Number = 0 Then
Response.Write("Send successful!")
Else
Response.Write("Cannot send your email: Error " + err.Description )
Err.Number = 0
End If
On Error Goto 0
end function
%>
| From: | | | To | | | Subject | | | Content: | <%=strBody%> | | | | | | | | |
|
Welcome to my website:
www.qitt.com
You can win if you want
|
|
|
|
|
Hi,
I think whatever you are saying is not a Open Relay, if I am right. You are sending mail through the SMTP servers with the mail account for which you have registered for yourself.
Perhaps for definitions of Open Relay and Third Party Relay, please check this URL.
http://mail-abuse.org/rbl/relay.html
Deepak Kumar Vasudevan
http://deepak.portland.co.uk/
|
|
|
|
|
Hi
I have a problem with font sizes on my webpage. At the moment I'm using
which shows fine on my browser, but way too small on others (all viewed on 1024 x 768 resolution). If I set the size to '2', the font is way too big on my browser, but OK on other browsers.
And don't want fixed font sizes, so what is the best option?
tx
|
|
|
|
|
I know this sounds obvious, but...
have you checked the Text Size you are using on your own browser?
(in the "View"/"Text Size"... menu in IE)
It sounds as though your own browser is set to Text Size "Large" or "Larger".
Another possible cause...
are you using a non-standard font, which may be installed on your own system, but not on anyone else's? The font could be being substituted for one that displays "smaller" given the same font size.
Hope this helps!
-- JON --
Good Fast Cheap...
(Pick two, you can't have all three!)
|
|
|
|
|
Yeah, I should probably stick to the "normal" fonts.
are there any templates on the web for web page designs?
tx
|
|
|
|
|
On my web pages, I tend to match the "normal" font size to that of the windows font. So I guess it doesn't matter what screen resolution other people are running because it would appear to be "normal" to them anyway. There will always be people that changed the fonts to the windows menus etc to what they want and as good a mind reader that I am, I just don't know what the user does with the fonts on their system. And I think at least if I set the fonts of the website similar to the standard system fonts then it would suit the majority of users.
|
|
|
|
|
I don't know about you, but I use <td valign = "top">... quite a lot when I build HTML tables.
I have however never learnt the equivalent command in CSS. Could someone enlighten me on this one? I've been looking everywhere on and off for a year, but has come up with nada. I search the net everytime I start a new project when I bump into this little "problem", but give up after an hour of wasted time.
Is it possible I have to fiddle with flows and offsets? Please don't tell me I've just missed some silly CSS property, or I'll have to commit harakiri. 
--
Shine, enlighten me - shine
Shine, awaken me - shine
Shine for all your suffering - shine
|
|
|
|
|
Try verticalAlign- auto
- Aligns the contents of an object according to the value of the layout-flow attribute.
- baseline
- Default. Aligns the contents of an object supporting VALIGN to the base line.
- sub
- Vertically aligns the text to subscript.
- super
- Vertically aligns the text to superscript.
- top
- Vertically aligns the contents of an object supporting VALIGN to the top of the object.
- middle
- Vertically aligns the contents of an object supporting VALIGN to the middle of the object.
- bottom
- Vertically aligns the contents of an object supporting VALIGN to the bottom of the object.
- text-top
- Vertically aligns the text of an object supporting VALIGN to the top of the object.
- text-bottom
- Vertically aligns the text of an object supporting VALIGN to the bottom of the object.
http://msdn.microsoft.com/workshop/author/css/reference/css_ref_entry.asp[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
|
|
|
|
|
Thank you very much! I can't believe I've been so damn blind!
Now, where did I put that harakiri sword?
--
Shine, enlighten me - shine
Shine, awaken me - shine
Shine for all your suffering - shine
|
|
|
|
|
Jörgen Sigvardsson wrote:
Now, where did I put that harakiri sword?
Right next to the Why Life Is So Great inspirational video.
Don't worry, I thought I knew a lot about CSS. I knew about vertical-align but only a few of it's values. It is a good lesson why you should not become dependant on what VS.NET tells you are possible values 
Paul Watson
Bluegrass
Cape Town, South Africa
Macbeth muttered:
I am in blood / Stepped in so far, that should I wade no more, / Returning were as tedious as go o'er
DavidW wrote:
You are totally mad. Nice.
|
|
|
|
|
Paul Watson wrote:
Right next to the Why Life Is So Great inspirational video.
Ah, found it. Just next to "101 ways to reach Sto-Vo-Kor" On a more serious note, life is great. I've never doubted that. It's just that it's great in too many ways. I could've settled with half. 
Paul Watson wrote:
It is a good lesson why you should not become dependant on what VS.NET tells you are possible values
How true! I'm baffled though that I didn't find what I was looking for at www.w3c.org[^]. I use the recommendation documents quite often. I guess I can conclude this with the cliché "It's hard to see the forrest with all the trees blocking my view"or whatever the saying is in English
--
Shine, enlighten me - shine
Shine, awaken me - shine
Shine for all your suffering - shine
|
|
|
|
|
Just looked and found vertical-align values[^].
Still, it is the browser implementations that are probably your biggest problem. Bet they are all over the place.
Paul Watson
Bluegrass
Cape Town, South Africa
Macbeth muttered:
I am in blood / Stepped in so far, that should I wade no more, / Returning were as tedious as go o'er
DavidW wrote:
You are totally mad. Nice.
|
|
|
|
|
Hopefully it will work out fine. The biggest differences between IE and Mozilla based browser I've seen, with respect to CSS, are sizes. Percent sizes in CSS behave very differently depending on if you've specified a size in the parent element or not. Very peculiar since old style width and height attributes seem to work just fine.
The only requirements I have are that this should work on IE and mozilla based browsers, and I will do weird and wonderful hacks to make it work if necessary.
--
Shine, enlighten me - shine
Shine, awaken me - shine
Shine for all your suffering - shine
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
