Recordset Object Vs Command Object
I want to open a recordset object on an .asp page. When I open the recordset I would like to use a stored procedure that expects a parameter to be passed for the stored procedure. I will then use the recordset to loop thru the recordset, update values from the recordset and then update the database by passing parmeters to another stored procedure.
I would like to use the recordset object but can it be used to pass a parameter to a stored procedure? Do I need to use a command object to open the records instead in
order to pass the parameter to a stored procedure?
View Replies
ADVERTISEMENT
I am getting the above error when trying to execute the following code:
View Replies
View Related
I have an online application. I get the following error when a user selects an option from one drop down list but doesn't select an option from another drop down list. Here is the error:
Microsoft OLE DB Provider for SQL Server error '80040e0c' Command Text was not set for the command object. Code:
View Replies
View Related
I have an online application. I get the following error when a user selects an option from one drop down list but doesn't select an option from another drop down list. Here is the error:
Microsoft OLE DB Provider for SQL Server error '80040e0c'
Command Text was not set for the command object.
Line 87
Line 87 = rs1 = conn.execute(finalSQL)
Here is the page causing the error. Code:
View Replies
View Related
I keep getting this error. I searched the forums, and found one. It said to basically replace elseif with else. It worked for that person.
I tried it and it didn't work. So what i decided to do was, remove all of the if statements and keep one. Even with just one if statement i get the same problem. Does anybody know what is wrong? It worked fine, up until i added the if statement. I need them there though for a reason.
Personally i think, it;s not getting the value from the request form, and hense it isn't picking anything up. What do you lot reckon? Code:
View Replies
View Related
i build my sql string by using bunch of if-end if statements, after storing the whole SQL string into variable strSQL i put into the command object's CommandText property like so:
objCommand.CommandText = strSQL
Set rsRec = objCommand.Execute 'rsRec being a recordset
then i want to be able to display the data:
While Not rsRec.EOF
Response.Write(rsRec("FIRST_NAME") & " " & rsRec("LAST_NAME") & " - " & rsRec("FIRM_NAME") & _
" " & rsRec("EMAIL") & " " & rsRec("CITY") & "<BR>")
rsRec.MoveNext
Wend
but this gives me an error saying:
Object doesn't support this property or method: 'CommandText'
View Replies
View Related
i keep on getting it for some reason. i am using asp Command text was not set for the command object.
View Replies
View Related
I have a recordset object generated by the command object
as in recordset object=command.execute
now recordset.recordcount gives me -1 !!!!
the actual record count is 7!!!
Any body who can tell em how to change the cursor type of the recordset
which is generated by a command object!!!
View Replies
View Related
i m retriving values from SQL Server 7 using command object through a query
Statement in bold format is giving an error in execution : Code:
View Replies
View Related
Microsoft advises not to pass parameters to the Command object in the Execute statement. Why?
View Replies
View Related
I am trying to close a command object after executing a command text and getting an error message as:
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'close' /data_usage_guide/workplansystem/ProjDataLoad.asp, line 67
The reason I want to close the object is to use it again for executing another commnad text as shown in the code below. Could any oen help why I am getting this error message and/or is there a better way to do this , i.e. posting data to several diferent tables one after the other. Code:
View Replies
View Related
Have no problem getting my select queries to work using this method:
strSQL = "SELECT tblUI.IPAdd FROM tblUI WHERE (tblUI.IPAdd =?)"
arSPrm = Array(strRemHst)
Set rst = cmd.Execute(,arSPrm)
Can anyone point me to some examples of using this method for UPDATE and
INSERT queries? Can't seem to get it to work no matter what I can think of
to try. (If it is possible?)
View Replies
View Related
I am trying to write out the results to the screen and save them to disk, but I can't figure out how to properly formulate the code.
I keep getting this error: Object doesn't support this property or method
Code:
View Replies
View Related
i'm using command object like this:
objCommand.CommandText = strSQL
strSQL being a SELECT string.
then executing it:
Set rsRec = objCommand.Execute
how can i get total number of records found, changing the line above to this:
Set rsRec = objCommand.Execute totRec
gives me an error and doing just this:
totRec = rsRec.RecordCount ....outputs -1
View Replies
View Related
i am using ASP 3.0 to create web pages for a college project and i am
having problems in using recordset object through session object to
pass data to all web pages.Anyone tell me how to make recordset and
connection objects sessional.please i have a project to finish.
View Replies
View Related
Does the recordset contain any information about the table itself, such as the table(s) name?
View Replies
View Related
Im having a few prblems with object recordset and
variables. I can print data into a table using
objrecordset("Type").
But when i try to assign the value
to a variable, ex. variable1=objrecordset("Type") i get
an invalid use of null error. If i take out the code to assign
it to a variable it works fine. So my question is how can i
assign the value of objrecordset("type") to variable1.
View Replies
View Related
i need a object/class/function that return me a array/object like this:
set oDataFromSQLServer = function_or_class(sql)
while oDataFromSQLServer.eof
value = oDataFromSQLServer("colum_name") oDataFromSQLServer.next
next
ps: I donīt want to use a Recordset in this case.
ps2: I don't want to use GetRows in this case, because it doesn't pertmit "string index" like array("columName")
View Replies
View Related
whenever i fetch any numeric value, having a zero at the end, e.g. 32080, from a database with a recordset object, i find that the value becomes stripped of the last zero, i.e. it becomes 3208.
View Replies
View Related
I just purchased a domain package from gate.com and am setting up my SQL database connection on there server.
I am able to connect to the database fine, however when I am creating a recordset it shows my main menu table (and other tables) like this.
truthhub@truthhub.com.mainMenu
(the system "default" tables have "dbo" as a prefix)
It doesn't show any columns in that table and when I test the connection from there it gives me an Invalid Object Name Error.
On SQL Server it shows "truthhub@truthhub.com" is the owner of the table...so I am kinda confused
If I go to the advanced tab and delete the truthhub@truthhub.com and just leave mainMenu, then I can test and see my results.. however this will be a very inefficient way to start the work on my new site.
Has anyone run accross this problem before, or does anyone know how to make Dreamweaver cut the truthhub@truthhub.com off of of my tables? ...
View Replies
View Related
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.
View Replies
View Related
I have a problem with my programm and get the error above. In the file I've commented the relevant lines with **** and normaly the SQL-statement are in one row but there is a better overview when it looks like this.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
We are using .net 1.1 on windows 2003 server. This is we are facing in our
production server.
When we are doing the load testing we are getting the bellow error. While
the load testing this error is not coming frequently. When we run 20 threads
for 3 mins we are getting this error message 2 or 3 times. But this line of
code is executed by all the threads. Code:
View Replies
View Related
I have a custom function for checking if a variable has been set or not to make the code easier to read, as well as to keep it shorter.
However, I'm getting errors that "Object Variable not Set", even after I've already checked for null and empty. Code:
View Replies
View Related
A three-tier user authentication system was running without a problem for almost a year and now is suddenly dysfunctional. We don't know of any changes to any of the servers. It's quite maddening. The details:
1) We know the COM+ app is instanced on the COM+ server (Win 2000). The component graphic spins when CreateObject is called.
2) The proxy is installed on an IIS server (Win 2000) with delivers the interface, written in ASP, to the client PC.
3) These are the error messages displayed when a method of DAMS is called: Code:
View Replies
View Related
I have one column in my access database named 'picture'. I uploaded the pictures in the database using OLE Object. Now I want to have a picture of an employe in my ASP form.
It gives me an error. The page works without that code-line where picture is mentioned. Code:
View Replies
View Related
I have an xml data that I want to store in a database.
I want the following fields
1. Account-id
2. order-number
3. first-name
4. last-name
5. address-line
6. address-line-2
7 city
8, state
9 postal-code
10 total-points-spent
11 the list of items that were purchased which are in the section
item-redeemed
And this is the asp code that I use to move through the list. right now all
I can get is the redemption top-level, but I cannot seem to go down to the
subitems. Code:
View Replies
View Related
I am creating an e-mail using the CDO object and using the AddAttachment method to attach a file from a URL. I am having a problem in that the file file attached is given a random name (something along the lines of ATXX412.pdf)
Does anyone know if it is possible to rename/assign a name to attached file before the e-mail is sent?
View Replies
View Related
I am writing a function to take a recordset as parameter, and print a HTML Select element according to the record in the recordset. I would like to check if the input object a RecordSet before processing, how can i acheived that?
View Replies
View Related
how to find the size of a pdf which is located on the server i know i have to use filesystemobject
View Replies
View Related
I have a table called "Document" which has 3 columns
Doc_ID
Doc_Name
Doc (this is a word doc stored as an OLE object in ms access)
Now in my asp if the user selects a document it should open the word file.
I have my case statement that looks like as follows which I think might need some
modifications to open a word file: Code:
View Replies
View Related