ASP & 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:
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Store Procedure
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....
Combine 2 Store Procedure
I 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.
Call Store Procedure For Inserting Data
I am just wodering in asp program, if there is anybody writing store procedure for inserting data into database since there are so many parameters need to be passed into store procedure(assume there are many columns in the table). I need to insert data into two separate tables, the relation between these two tables is 1 row of data in table1 could have multiple rows in table2 related to table1, but if the data insertion into any one of the tables is failed, the transaction will roll back and no data will be remained in any of the tables. If this needs to be handled in asp program using transact sql, how do I implement it. If I need to it using store procedure, how do I pass the error or success signal to asp program from database.
ASP Store Locator
where 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.
Online Store
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?
Store A Query
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?
Store New Values
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
Store Locator
i'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?
No-cache Vs No-store
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?
Store A Recordset
I'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.
Store The Values
I'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.
Store String
when i perform this: Session(username) = Request.Form("username") and print it out: <%= Session("username")%> it doesn't output anything.
Store Locator
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?
How Can I Store Images Using ASP & SQL Server!!
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.
Store Info In Database.
I 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 , ???
Store Connection String
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?
Store Session Variable In DB
I 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?
Candy Press Store
Has anyone used Candy Press.The price they are asking for for the Admin component is very reasonable and affordable.
Make An Online Store
how 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.
Get Image And Store In Database
How 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?
Store A Database Value In A String
I 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.
XML Format To A Store Proce
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?
Best Way To Store Database Password In ASP Application?
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.
How To Store A Class In A Cookie And Retrieve?
I have the following script: <%@LANGUAGE=Javascript%> <% var myClass = new LoginInfo(); myClass.sessionID = "1321312131"; Response.Cookies("testingCookies") = myClass; var recievedCookies = new LoginInfo(); recievedCookies = LoginInfo(Response.Cookies("testingCookies")); Response.Write(recievedCookies.sessionID); Response.End(); function LoginInfo() {var sessionID;} %> How to make it work?
How To Store Multiple Mailing Addresses
I want to store multiple mailaddress like home address and shipping address. Sometimes addresses will be more than two. I am thinking about storing the details as a dictionary object....
How To Store Output Of An ASP Page On Server...
The result of my asp page will not change for a week. So instead of querying the database every time a user visits this page, an HTML page is sent to the browser. How can I accomplish this?
Input=hidden - How Much Data Can It Store?
Can someone tell me if it is possible to store the contents of a TEXT AREA field in HIDDEN FIELD in another page after the initial form containing the textarea is submittted.... I need to do this to seamlessly present the submitted data in an attractive format while hiding his submitted data in the hidden field...but I am not sure if there are restrictions of eg 255 characters for a hidden field?
Resize Photo Store On Server?
I have a Windows 2000 server. My ASP application allows users to upload a photo for display to other users. Unfortunately everyones photos are different sizes. I'd like to resize the photo to 150px wide while maintaining the aspect ratio of the photo. Is there anything built into IIS/ASP that will allow me to do this? If not, is there a free DLL, etc. that I can add to the server?
Store Part Of URL In Session Variable?
I've spent ages hunting for this but no joy, another user suggested cookies, but was ideally hoping to use Session Variables so its just stored while a user is on the site. Basically I need to capture a section of a URL i.e. www.myurl.com?ref=thisiswhatIneed! I then need to simply save 'thisiswhatIneed' into a session variable and then enter it into a form box on another page (which I know how to do). I just don't know how to get/store the part of the URL?
Asp....login...store And Retain Information
I have an asp driven website using an Access database. Basically the user arrives to the site selects the product from a list. From their they are directed to another page where they see the starting price and then they can customize the product from a list of options that is also database derived. The result is a final price. What I would like to do is have the ability for the user to save that product and on their next visit bring it back up along with any other products they saved. (note...all I have is done using asp classic, access database, and some javascript) Could someone direct me to a good or source or help me get started on how to create a user logon and retain their user info and how to do the above?
File Upload And Store Name In Database ?
I am trying to write a page that lets the user upload any file to a server and this also stores the name of the uploaded file in to the database. So far I'm not having much luck. I am a novice with ASP and really could do with some help. I have been trying to use ASP Upload but it is confusing me as how to modify the script to allow me to insert the name of the File in to the database. Here is my form page (you will notice this checks to see if we are uploading/editing or deleting). Code:
Store Values In Table Cells
I have created a table that I want to fill with calculated values. I have given ID's to each cell. This must NOT be the way since I can't address these ID's. How do I store values in table cells from my PostBack?
Store Javascript Document.forms[0].value
Would it be possible to store javascript document.forms[0].value to ASP session as global variable? If it is not possible, how can I pass the javascript document.forms[0].value to ASP/vbscript function? I need to pass the javascript value to ASP/vbscript function because I have to store the javascript value into database. I can't use Request.Form for getting field value. Because there is a submit button in the same form for calling email function in another ASP page.
Session Variables, Store User Id Etc
Is this a good idea, or do people use different approaches ? Believe there's a 20 minute time period for em which doesn't sound like what l need.
Session Variables Store Array Of Values?
I know that cookies can store an array of values, which can be accessed like this: tempid = Request("cookiename")(i) Is it possible to use session variables in the same way? Store a array of values in the same session variable and access them on another page by indexing? I've looked around alot and I've not found anything suggesting that this is possible. Right now I'm using a single set of cookies to store info on a series of purchaces of the same type of item. I'm hoping to use session variables to replace the cookies. Does anyone know for certain if this is not possible?
Encrypt & Decrypt Password And Store In MS Access DB
I am trying to encrypt the password and then store in Access DB. I have check out already existing threads on Sitepoint and read the artile at 15second.com (Password Encrypt/Decrypt using MDI ). It works for SQLServer. I tried it. It works.. But i am using MS Access Database, and it doesn't have any binary data type in it. So MDI is not working for me here. I havn't find any help. I am looking for your help now as i have give it up and this thread is the only hope for me now. I need to Encrypt/Decrypt the password while using Access at backend.
Storing In Session Variable Making Me Store It Twice?
I'm using a session variable to store a log in so the user only has to log in once every time they come to the site for multiple features that require a password check. What I'm doing is using one central login page that pops up when they click on whatever locked feature they're going for. The password form's action is back to this same page, which has this code towards the top: Code:
Using Access To Store A Word Document And Use It For Mailmerge
I am presently saving a word document to an access table in a OLE Object field. I retrieve the document and display it fine. I would like to retrieve information from one of the other tables and merge the two together. And then display the new word document. Inother words do a mail merge or replace.
ADODB.RecordSet Object To Temporarily Store
I would like to use an ADODB.RecordSet object to temporarily store some data and then iterate through it. Actually it needs to be a RecordSet only because it is a perfect choice as data structure for what I want to do, I don't want to actually run queries or update tables with it. It seems to me, however, that the RecordSet works only if there's a query behind it. ADO complains about the RecordSet not being open when I try to add rows by the AddNew function, or try to add fields to it. Is there a way to use the RecordSet without actual database date behind it? Or is there maybe some object in VBScript that provides the same or at least similar functionality? (Apart from Scripting.Dictionary, which is great, but I would like to use something more similar.
ASP Procedure
I have the following code: <% Sub makeSafe(theString) theString = Replace(theString, "'", "''") theString = Replace(theString, chr(34), chr(34)) theString = Replace(theString, "=", "-") theString = Replace(theString, "_", "-") theString = Replace(theString, "../", "") theString = Replace(theString, "--", "") theString = Replace(theString, ";", "") theString = LCase(theString) End Sub %> I then call it using Code: thePassword = Trim(request.Form("password")) thePassword = makeSafe(thePassword) but i then get an error message saying Quote: Type mismatch: 'makeSafe'
Stored Procedure
if session timeout end, normaly i make some sql changes and redirecting to login page... but if user closed the browser i cannot made those sql changes. is it possiable, and how, to write a stored procedure in asp that will see that the timeout of session("x") ended and will do this changes from the server side?
|
TRACKER
