I have a stored access query which is corresponding to a particular id. However, I am using a login script to capture the value of an id. Now, I want to dynamically open the stored query by passing the id captured via login.
Which means, I need to erase the static id value associated with the stored query GMISExpenseCombo. how do i open this stored query by passing the id value to the stored
query. I am using this stored query to retrieve some financial data for the corresponding record. Currently, I am opeing the static stored query as follows RS.Open "GMISExpenseCombo"
I am using Crystal v7. Main report and subreport are both based on the same stored procedure. How do I pass parameters to display the report and subreport in the Crystal viewer. I can display regular (non-sub) reports fine.
I am trying to pass some paramters from a VBScript function to a script that writes the parameters to a text file. I have not been able to do it. Code:
I am passing a text parameter with querystring like
..asp?parameter
How do I pass a parameter which itself contains the "=" character?Eg if parameter ="a=b" then the code will interpret is as a parameter named "a" with a value "b", where as I need "a=b" being the value.
I have a simple JS function that I want to return a true or false value based on the parameter passed in. At this point of time I receive the error "'True' is undefined". Here is my code:
I am trying to pass a VBScript Date variable as value to an ADO adDate parameter of a stored procedure (which runs in an SQL Server). If I add the parameter like this:
where oCmd is of type ADODB.Command and dParam is a VBScript variable of type Date then when trying to execute the stored procedure I get the following error:
Optional feature not implemented
I was able to get round this by passing a string value in an adVarChar parameter, but it would be easier and more readable with adDate and Date-type variables. Is this latter possible?
I need to use varchar(max) for my out parameter (@resultText) from the 4000 length it is currently using. When i change the length to -1 or drop it altogether i get an error, how can i fix this issue? Code:
I have the following test.asp page which needs one parameter querystr but my querystr is a very long string value. When I send a long value the query string is getting truncated after some characters.
Can you please kindly share the code segment to workaround how to pass such a long string value to a asp page. This is how I invoke the test page:
http://localhost/?querystr=select ............ from xxxxx
but part of my query string never gets passed to the asp page appears asp as a limitation on max string length can you please provide me a workaround how I can overcome and pass the right string to asp.
I am attempting to pass null as the input value from a series of textboxes if the user does not input a value prior to submit. To try and do this, I am using a vbscript function on this asp as follows:
I was hoping this would convert those emptystring textboxes to null.
Then, these variables are input in an update stored procedure called from the same asp upon submit. This handles ntext and like fields in the table I am updating, but a null value passed in this way for a numeric field chokes. The error on the asp is something like, "unable to convert value of type text to numeric". Can't null be passed as a parameter value when the field type is numeric?
How does one pass null for a parameter's value in a stored procedure on an asp? Am I missing something here?
I'm trying to pass parameters from an ASP (VBScript) web page to a Stored Procedure in SQL Server. I know how to do the Stored procedure but it's passing the parameter from the web page that is stumping me.
I would like to upload an image (got File.Binary from ASPUpload) with a stored procedure.
It works with a normal recordset with new/update and in ASP.NET, but in Classic ASP, I can't find the right constant in adovbs.inc to use for the parameter:
is it possible to pass an array into an Oracle PL/SQL stored procedure from ASP? I'm trying to upload approx. 15 000 rows into Oracle and for security reasons am only permitted to access the database through PL/SQL. At the moment I've got it uploading one row at a time by looping through but this is extremely slow.
I have a problem that I wasn't thinking of when I did this snapshot reporting in asp. Ok here it goes. I have a Access database that has my queries and reports.
I have some queries in access that have a parameter in them, like enter first date and enter second date to give me the range of record and total for the reports. Well, this asp that I have for doing the reporting does it server side. Code:
I'm new to this and I'm trying to take data collected from this nice form I created, and pass it to a MS Access database. To simplify my learning, I created a database name test.mdb. It has one table, customers. The table has 3 fields, name, address, and phone. There are 3 form fields that have the same names as the table field names.
i have setup a form on a normal http page which collects name address etc and is then passed to a https page to collect credit card details, on clicking submit on the https page the credit card details are inserted in db on secure server along with one field that was passed from the http page (the user id).
this all works ok, however i then need to pass the remaining orignal form values back to another http page that then inserts these values to another DB. ok you may be asking why.... the first forms allows the user to correct information already held on file before upgrading their listing, i then need them to pay for the upgrade before inserting the amended data in the orignal database... How..
A client has an OLE field called Signature in an Access database. The field contains a GIF image of a scanned signature (that a product has been received). How can I show this on an ASP page?
A client has an OLE field called Signature in an Access database. The field contains a GIF image of a scanned signature (that a product has been received).
my stored procedure in access XP (I create it Succesfully) It returns me all records.. For example in my db there are records with catid=1 but no record with id=2
I try my code both catid=1 and catid=2 it returns same records.. What is my fault..? Code:
strSQL="SELECT * FROM MyTable;" rsSet.Open strSQL, adoCon ...do some stuff... rsSet.Close adoCon.Close
Set rsSet=Nothing Set adoCon=Nothing
I have a couple queries stored in the database that I use when in MS Access. Can I call these queries instead of using a string to specify the SQL command?
The above seems kind of verbose for making use of a database. Can it be simplified at all?
I'd like to transfer al my hard coded sql queries to access stored queries and use them with parameters. Actually, I did not find any strong information how to do that. Please, provide me official information, or give me at least one example of using it(with Select statement or other).
I'm pasing a zip code as a prameter to an Access stored procedure. In Access the parameter is a text data type. It works for non-leading zero zip codes but, apparently access (or ASP) is converting it to a value first (dropping the zero) then sending that to my SP.
Even if I use cStr() to be sure the parameter is sent a string it still seems to drop the leading zero. Any thoughts? Note: It needs to be a string for canadian zip
I have a client who has had a ASP site with an Access database for several years. It stores information for the used cars on his lot. I have stored text in the database that points to the location of the image for each record. Each record will have a thumb image that is supposed to display in a list of vehicles available then the user can select an item from this list and a new page displays with the information and the regular size image. So far everything has worked fine exept for the display of the images which are stored in a separate directory called veh-photos. All I get are image place holders. I am using Dreamweaver 2004 and and Access 2000 for the database.
A MS-Access database table has 2 columns - UserID (unique) of number data type & UserName (text) along with some other columns.When users come to a particular page, say, AllUsers.asp, all the UserNames are displayed to him as hyperlinks. Based on the UserName clicked by a user, the next page (to which the user will be taken to when he clicks any of the UserNames) will display more information about that particular UserName (which the user had clicked).Assume that the page where more info is displayed is named UserInfo.asp. (Note that the info will also be retrieved from the DB table).
UserInfo.asp will also display the UserName the user had just clciked in AllUsers.asp. Now for UserInfo.asp to retrieve data about the UserName the user has just clicked, I can make the links in AllUsers.asp pass the UserID as well as the UserName as a querystring value. Now whcih one will be more efficient - sending the UserID as the querystrinng value or sending the UserName as the querystring value?
I got a problem returning parameter. I am storing date using datepicker to choose my date. But when i want to delete it from the table because date is one of the primary key. it has problem when i retrieved it because it is recognized as datetime but when it display it's a text. i need 2 convert from text to date. how would declare my parameter then?
I am using Ultradev to develop asp pages with Access database. With the help of some online friends & tutorials i am studying this. I need some help for the following. I am having 2 tables,
Table 1 with Company Name & Country Code Table 2 with Country Code & Country Name.
When some one searches for a company, it should display me the Company Name along with the Country it belongs. Someone told me that it can be done by passing a parameter value from one recordset to another on the same page, but i dont know how to do this.
myGetImage.asp is suppose to create a temporary file in the client side, and display in on the client web browser. myGetImage.asp needs to know the clients web browser temporary system path, in order to create the temp file. How do I get the parameter and value of clients web browser temporary system path?