The connection object is stored in a application object in a database.asp file which is included on all the pages. This is something that I didn't code but I am incharge of fixing it because we are having alot of problems with the IIS.
How do I remove the connection object from the application object? I am a bit confused, what if i just use a variable to set the connection and then still include the file on all the pages. Would that work? Code:
I have actually an asp web site which use the global.asa file to connect to
the database but for security reason, I want to put username and password
information (or the complete connection string) in a seperate file so only a
special user could read these informations.
I run a small finance company and would like to add an online application form that potential customers could fill in.
at present all they do is email me asking for a loan, but if i could create some sort of form where they enter their details in each box, then click submit i think this would look alot more professional. Does anyone know of any tutorials or anything that may be able to help me along my way?
i am making a site using asp. in this i am using mssql server2k as backend. i ve created a dsn. i want use global.asa file for creating connection object so that i don't ve to create con object in every .asp page. for that i ve write following code
<script language="vbscript" runat="server">
sub Application_onStart()
set con=server.createobject("adodb.connection")
con.open "dsn=pc;uid=sa;pwd=;database=dbname"
end sub
sub Application_onEnd()
set con=nothing
end sub
sub Session_onStart()
end sub
sub Session_onEnd()
end sub
</script>
now anyone tell me how to use that connection object in any asp file for fetching the recordset.
Why doesn't the following code work?
Sub Session_OnEnd
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = Application("Connection_String")
Conn.Open 'here is the error
....
End Sub
A Conn object is created the same way in Session_OnStart and is used throughout the application, and Application("Connection_String") still exists here (I tested). So I suppose the error is caused by the fact that we are in Session_OnEnd.
Rather than opening and closing a new connection to the database on every page, I have placed that connection into an Application variable. This has worked fine so far.
My issue is that I have a logoff page where it closes that connection.But this means that users who are on the application will not be able to access that connection.The obvious answer is that I don't close the database connection.But my problem is, I would like to eventually close that database connection.
How can I determine if an application variable (not session variable) exists?How can I determine that there are not any users on the application?
I'm working on a quick wrapper so that I can connect to a database, run a quick query, get the needed info and pass it on to the next page that needs it. I've been programming for a long time but not with ASP/VBscript and think it's just something stupid that I've overlooked. Code:
View Replies View Related1.
conn.ConnectionTimeout = 60
conn.Open connString
2.
conn.Open connString
conn.ConnectionTimeout = 60
Do both of them give different?
I'll admit my ASP skills are very rusty, and come seeking help.
I'm currently using a dictionary object to store a multi-dimensional array.
I want to pass this dictionary object to an object, which holds an array of dictionary objects.
However I'm finding that the array is not getting set, thus I'm having great issue with dynamically resizing the object's property for every new dictionary object I'm adding.
I have a VC++ COM object which fires an event. I've written VB EXE apps against it and they receive the event notification.
I've now built a simple VB COM object which uses the VC++ COM object internally.
My question is, assuming the ASP page which loads the object does not immediately exit, will the VB COM object be able to receive the events from the internal object?
I found a simple date script, which is this:
<%
var_date=date() 'get the current date
var_date=FormatDateTime(var_date,1)
Response.Write(var_date)
Wednesday, September 29, 2004
How can I get this to not display the day of the week, I only want - September 29, 2004
I found a simple date script, which is this:
<%
var_date=date() 'get the current date
var_date=FormatDateTime(var_date,1)
Response.Write(var_date)
%>
Wednesday, September 29, 2004
How can I get this to not display the day of the week, I only want - September 29, 2004.
i have a variable which holds a value like this
stramount=Trim(Request.form("txtamount"))
response.write stramount
the output sometimes is
50.00 or
50 or
50.
if it is 50.
i want to remove the (dot) at the end. can someone tell me how to use the instr function to see if there is a dot at end and if it is there then remove it.
i have problem in removing the gap between two images, pls see the attached image. coz my item name is quite long, i dun wnat it display in horizontal, i want it display as vertical. so i create the images for the character and use ascii to recognized it.
my code is as below:
<td align="left" class="BorderLeft" width="1%">
<%dim word, pic, word1
word = "AAAAABABABBA"
pic = ""
for i = 0 to len(word)-1
word1 = cstr(right(left(word,len(word)-i),1))
pic = asc(word1) & ".gif"%>
<img src="../images/<%=pic%>" border=1 vspace=0 hspace=0>
<%next%>
</td>
How can I remove a cookie from the client in ASP? I'm not talking about setting the value to a blank string and I've tried this:
[vbs]
Response.Cookies("mycookie").Expires = Now()
[/vbs]
and
[vbs]
Response.Cookies("mycookie").Expires = Date() - 100
[/vbs]
Neither of which work.
Is there any way to completley remove the cookie?
can anyone temme the script or style sheet to remove the hearder and footer url address of the web page when printing the pag
View Replies View RelatedHow to write asp code to remove duplicates in an array.
For Eg: A()=(1,5,10,15,10,20,5)
After removal of duplicates it should be
A()=(1,5,10,15,20).
The main idea goes like this: I have a textarea, on the right I have a listbox whose elements are loaded from an Oracle Database, I want to have an "Add" Button which when pushed will insert in the textarea the value selected on the listbox between "{ }" (ej, The {white} cat), you can add as many values as you wish and also manually edit the text, and a Submit button which open another ASP page that will check the sintax of the textarea and insert it on the Database.
So far I already have the part which checks the sintax and inserts it on the db, and the listbox with the elements you can insert on the textarea, but my boss really wants the "Add-Remove" feature and I need to finish this for Tuesday
I have image icons that are clickable. I want to remove the hyperlink from around the image.
I tried the STYLE="TEXT-DECORATION: NONE" tag but thats not working. How should I remove the underline from the hypelink.
Code:
strImage = "<A target=""_blank"" href=""document.asp?job="
strImage = strImage & jobid & "&doc=" & filename & """ STYLE="TEXT-DECORATION:NONE">"
strImage = strImage & "<IMG SRC='" & GenerateIcon(rs("filename")) & "'/></A>"
Would search for this but forgot what its called? I wanna remove everything from the left of the camma in a variable:
43,7-3-05
to 7-3-05
I am wanting to create a large dynamic web site with an accessible Text Only version.Instead of creating additional pages for the text only version, is it possible to implement some regular expressions, which remove all the IMG tags from page.
I have found a useful tool at http://tantek.com/favelets/ which removes the CSS from the page but I also need to remove the images.Are regular expressions the best means of doing this?
I have an array like this:Code:
arrColour = split("blue,blue,green,red,purple,blue,green,yellow",",")
What I need to be able to do is to remove all items of the value "blue" from the array. I can just run a dictionary function to delete all duplicate values, because some of them need to be retained. I just need to delete all of them of a particular value. how this can be done?
Response.Write "<TD>" & "<a href= objRS.Delete>Remove</a>" & "</TD></TR>"
I have a basket which people add stuff to that they want to buy. i want a code that allows them to delete the item too. how the basket works is. thy choose a item from stock page and then it adds to a basket table.
I have declared a multidimensional array as follows. dim parray(100,5). Now this array contains some duplicate values. So how to remove duplicate values in this multidimensional array.
View Replies View RelatedHow can I get a string from this
22, 32, 43, 23, 44,
to this
22, 32, 43, 23, 44
I want to cut the last coma.
I have a page which takes data in an HTML table, and exports it to an Excel file. It works fine, but I want several things about the spreadsheet to look different from the HTML version. Things like fonts and colors. I think I can use a style sheet for the latter, but I haven't figured out how to remove hyperlinks from some of the items. On the HTML page, the hyperlinks are useful, but I don't want the spreadsheet to have them.
So on my ASP page which builds the Excel file, I have this: ...
used to other languages and using ASP for a particular project. Is there a way in which I can remove the first element from an array and then return the array with remaining elements intact?
View Replies View RelatedUsing ASP/VB I need to remove unwanted commas from the end of a field
that will be use in an array. There are items in the field that are
comma separated, so I don't want to remove them, just the end ones,
could be anywhere up to 5 unwanted commas.
Any ideas?
how to take a string and output it such that the last 4 characters are removed (.txt, .pdf, .doc, etc.)
View Replies View RelatedIs there a way to remove item from cookie collection that has a key to it...
--
Response.cookies("items")("item1") = "111111"
Response.cookies("items")("item2") = "222222"
Response.cookies("items")("item3") = "333333"
Is there a way I can remove items- item2 and rearrange above cookie into
Response.cookies("items")("item1") = "111111"
Response.cookies("items")("item2") = "222222"
How can I remove the page.asp link from the address bar? For example I have a link called www.mysite.com/page.asp?f=1, after the user clicks on the menu navigation. How can I get rid of page.asp?f=1 so that only www.mysite.com appears? Another thing, will request.querystring still work then?
View Replies View Relatedhow do I get a reg exp to remove part of a string? -
I have: '/page/txtonly/index.asp' and I want to remove the '/txtonly' to end up with: '/bobby/index.asp'.
I'm trying to remove a period in a username. For instance, I want:
First.Last to look like FirstLast