I am using ASP and VBScript to access an Oracle database and display query results to my users.
However, my query is huge! and I want to keep the query separate from my ASP/VBScript code.
How do I store the query on one page and then call it from another page?
how to write store procedure in asp?
View Replies View Relatedwhere I can find an asp script(free) to do a store locator.
I've only been able to find 2 on the web, and they are both at a cost.
I am looking for some ASP - SQL server 2000 online store application that i can buy for my company. This store is completely internal for the company and will be on our intranet server and will be utilized by the company employees to buy company merchantdize.
Also at this time there will be no credit card processing as the amount of purchase will be deducted from the payrol. I will be needing the shopping cart and product view. Later if we provide the credit card processing, we have already installed PayFlowPro from verisign and do creadit card procesing on our main site.
Does any one know such application that i can integrate with our style sheets and general layout?
I have this problems regarding "storing New values into session".
Take the "online movie tix booking" as an exmaple. When i click on one seat, beside storing the seatNo into a session, i also want to store the number of seats he has clicked throughout. How can store the incremental of seats clicked into a session by overriding new Values
i am stuck with the following error message
"Application uses a value of the wrong type for the current operation."
did anyone know the reson this occur?
just because of my store procedure....
I have an ASP page and a Store Procedure but I keep getting this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'sp_searchresultsZIP' expects parameter '@xDateTo', which was not supplied. Code:
what is the diference between these two cache control header.no-cache and no-store.I have read the w3.org explanation.So lets say I am using only no-cache ....my understanding is thatnothing is cached and nothing is writen to disk.but what happens when we use no-store....i think..nothing is written to disk but it could be cached.
Now my question where is this cache located...is it only in memory ?....if it is written to disk how log is it there and when does it gets cleaned.Is no-cache more secure than no-store ..why?
i found that OLE won't work. any alternative?
View Replies View RelatedI'm having need of storing a recordset in a collection tempararily. Can I hold a record set in a Collection object ? Any other way of holding a record set is also works, except arrays.
View Replies View RelatedI've been trying to come up with a method to store the values of a forms variables into a basic text document, say a notepad txt file. Its a windows server that im experimenting with and I'm not experienced with PHP, so im trying to find a easy way via either javascript/html or asp.
View Replies View Relatedwhen i perform this:
Session(username) = Request.Form("username")
and print it out:
<%= Session("username")%>
it doesn't output anything.
how do i store a value from a XML into a ASP variable
I need to store "maxpage" into a variable call "totalpages" in my asp file...how do i do it?
Does anyone know where I can find on the internet a good web site that can explain to me how a Store Locator script works using ASP and a SQL database?
View Replies View Relatedwhen some data is being into my database, most of the data is recieved from a form.
2 of the fields are dates, but looking at the db (access) the dates are stored in the '38307' format. - is this the standard way access stores dates?
Now, how do I get it to enter /todays/ date into a column? I thought it would be something like
RecordSet.Fields("LogDate") = today()
but this is wrong, right?
The other date, is to be entered by the user in the form. Now, what is the best way of going about this? It will be in a different column, but in the same format. My default, it would be 'todays' date, but needs the option of being changed. Any ideas? Code:
I created a table with varchar field where i want to store
the path of an image.
I will then use this file to retrieve this image on my
browser. Everything goes fine when i use a simple html
command as :
<img src="C:InetpubwwwrootMyWebimagesone.jpg"
height="200" width="200">
this is a hard-coded path. Hence no problem.
But when I store in the database path value: Code:
i m creating a site using asp in which i will collect user details, means their names, address, other information along with their pictures, so please can any one help me by telling how can i strore pictures in sql sever using asp. in very long detail. and how can i retrieve snaps from data base to display on the pages.
View Replies View RelatedI have made a registration form for adding my friends information in a
database. The problem is that I want to connect the persons with companies
in the same database. I wonder how i could connect a person to several other
id's in a table.
I wonder if I can make a string in the database that holds all the id's
separated with , for example....?
the string would then look like this:
1,4,6,22,56
for example...
But how can I then open this string and separate the numbers from the , ???
I usually create a db.asp file, and include it on each page i need the db connection, but where do you think is the best place to store the db connection? anything a bit more secure?
View Replies View RelatedI would like to ask izzit correct that assign a variable in asp and store the value select from XSL list at below: (in my asp page) Code:
View Replies View RelatedI want to maintain the user's session variable while moving from HTTP to HTTPS. I learned that you can store the sesison in a database, but I am not sure about the logic behind this method.Can someone explain how this works?
View Replies View Relatedi'm looking for a script that would help me establish "find the nearst store to you, enter your zip code here" i have the DB with the stores and i want some help with this?
View Replies View Relatedthis gives an error;
strLink = "<a href="member.asp">Member Area</a>"
how do i fix it??
Has anyone used Candy Press.The price they are asking for for the Admin component is very reasonable and affordable.
View Replies View Relatedhow much it would cost to make a proffesional looking online store (to sell computers). Make the items customizable, make it bill the user, and print the specs out to a file? I have no asp expirence, i was wondering how long it would take or how much it would cost.
View Replies View RelatedHow do I take an image from <IMG SRC>? Meaning I can not insert the image with the Upload method, I have to take it directly from the <IMG SRC>. Is there a possible way to do that?
View Replies View RelatedI have run a sql select statement against a table in my database. I would like to store the value retrieved in a string. How do I do that? So far I get an empty string when I run my code.
View Replies View RelatedI have a variable which has numbers like these
str="01-11-23-034"
i want 01 to be saved in one variable,11 to be stored in second variable and so can like
str1="01"
str2="11"
str3="23"
str4="034"
About ten days ago I got an idea from Anthony that in sql 2000 I can pass many parameters through xml to store procedure. Any resouces or web site example I can refere to?
View Replies View RelatedI have 2 store procedure, I need to pass both into the asp page, and combine the result set of two. What is the syntax or the approach to do this.
View Replies View RelatedIs it possible to store session state for each separate user in a separate process? We have a COM component that we want to use that is not thread safe and has to be isolated. We would like to store this in a separate process for each user.
View Replies View RelatedMy code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
I am new to ASP security. I want to know what is the best way to store
database password in ASP application? Or if there are any places to
store in IIS? I tried to store the password in VB DLL file, but looks
like when I open the DLL file, I can still see the plain text password.