How To Create And Use Disconnected Recordset
I want to create a disconnected recordset and want to store the values in a txt file at client site and then want to use for some validation.
View Replies
ADVERTISEMENT
Disconnected Recordset
Recently in an interview (for the post of ASP programmer), I was asked "How do you define disconnected recordset in ASP". I was stumped & couldn't answer. What's the answer to the question? Is it GetRows()?
View Replies View RelatedDisconnected Recordset In Function Not 'SET'ing
I'm trying to encapsulate a disconnected recordset in a function, but I'm unable to shift the recordset object to the Function variable. I close the Function's recordset and database connection, and in my main page, I lose the data. Here's the function: Code:
View Replies View RelatedTrying To Create Array For Recordset
I am trying to find distinct hostname. And my code is:
sql="select distinct a.Hostname, b.Productname from TableInventory as a, TableProduct as b, TableModel as c WHERE a.ModelId=c.Model AND c.ProductId=b.ProductId"
rs.open sql, cnn
After which im suppose to get the indivual hostname's productname, qty and cost.
i tried to split up the rs into array values Code:
Create A Recordset With Multiple Tables?
My database has customers, orders, and orderDetails tables. I'm trying to create a page that we can access to lookup all details about our orders. That page will need information from all of these tables.
How do I create a recordset that can handle the relationships and bring in all data?
Create Comma-delimited File From .asp Recordset
Is it possible to have a search page that queries a sql database and then writes the results to a comma-delimited text file instead of displaying the results.
I have no problem creating the search page and displaying the results I just don't know how to create the comma-delimited text file from the recordset results.
Create Recordset, Loop, Update Second Table
I am in the process of rewriting my table formats for an Access Project that was created. I now need to get the data from 1 table and transfer to a second table.
I created a page that creates the record set, I then loop through that record set and need to run an update statement to a second table, however, I get the following message:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
/BusPlanTest/updBusPlan.asp, line 17
Below is the code I am using: Code:
Create Database And Create Table On One Form
Here's what my code looks like...
View Replies View RelatedError Type: ADODB.Recordset (0x800A0BADODB.Recordset (0x800A0BCD)
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
Recordset Controlled By Another Recordset Within A Loop
I have created a forum, in which I have 3 tables:
1: Table_Forum
2: Threads
3: Replies
I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:
Create A PDF From ASP
Is there anyway to generate a PDF using ASP Scripting(VB Script).
View Replies View RelatedCreate Pdf
Does anybody knows a way (free of cost, code or dll) to generate pdf?
View Replies View RelatedCreate Url
I use a website in asp for which I have to type a username and
password everytime I want to login.
On the form are two fields for typing the username and password and
one button LOGIN.
I want to create an standard url for the website which includes my
username and password so I don't have to type it in everytime.
I looked at the page source but I can't find the right string.
I thought maybe http://.........aspx?username=me&password=it
but that doesn't work.
Create PDF
Is there a (simple) way to create a PDF file from ASP?
View Replies View RelatedCannot Create A Asp
I have 2 developper machine running visual studio 2003 and Windows 2000. On the first machine (Machine A) I may create a new asp project without problem. On the second (Machine B) I cannot create a new project.Visual Studo create the project but not the initial files and freezes.
But I may create a new project from Machine A using the web server of machine B.I have checked the access rights of both servers, the access rights on directory wwwroot and inetpub.Everything seems the same.
Create A TGP In ASP
Has anyone seen or know if anyone has done this? I think that ASP would be a great tool to do this with but I am curious if anyone has tried it and found it to be too hard or too burdensome to follow through with?
View Replies View RelatedCreate New User Using IIS/ASP
I'm running IIS5 on a Win2K server, and I want to have an ASP page that
creates new users. I have some simple code to test this, but am getting
a "500" error when I run it. The ASP looks like:
<%
strDomain ="Foo.com"
strUser ="Foo1"
' Create new user with password
Set oDomain = GetObject("WinNT://" & strDomain)
Set oUser = oDomain.Create ("User", strUser)
oUser.SetPassword = "password"
oUser.SetInfo
%>
Just for this testing, I've added IUSR_machinename to the Administrators
group, but am still getting the 500 error.
Create Object & DAO
how to create dao.tabledef object in asp:
I need to convert the following code into asp:
Dim tdf As DAO.TableDef
Dim db As DAO.Database
Dim fld As DAO.Field
Set db = OpenDatabase("C:Mydb.mdb")
Set tdf = db.TableDefs("Table1")
Set fld = tdf.CreateField("Field2", dbText, 10)
tdf.Fields.Append fld
Create Hostheader With ASP
Is there a way to create a host header in IIS with an ASP?
View Replies View RelatedHow Can I Create A Guestbook?
I want to create a web page for my friends.(I have a subdomain and my server supports ASP scripts) It will contain a small basic guestbook.It must write the entries to a text file on the server.And i must be able to view the guestbook.
View Replies View RelatedCreate ASP File On The Fly
I'd like to create ASP file on ther server side. Can I use
fso.createtextfile("c:folder est.asp")
Do I need to create a folder too?
Trying To Create A Menu With ASP
I am trying to create a menu with multiple tiers. I want to use the one menu as an include file throughout the site. Depending on what page you are on, I want the 2nd and third tiers to show up.
The rest just show the tier 1 links. I'm pretty sure this can be done in CSS, but the problem is that with a very big menu, I'd rather not have to load up the entire menu when it all won't be showing.
There for I figured I could create it in ASP. I could set some sort of parameter in the page so the menu include file would know what page I'm on, and then would only show and load the 2nd and 3rd tiers of that section. Is this possible? Code:
Create Xml File With Asp
is it possible to create a xml file and save so that i can upload with asp?
View Replies View RelatedCreate Flowchart
i want to create flowchart/flowdiagram like msword.And the user type inside the rectangular what they want to do..
View Replies View RelatedCreate Txt File
How can I simply save some data into a flat file (.txt) ? I've some data available and if the user clicks on a button it will save that data into the flat file... The user also need to define the directory (as in VB the common dialog box)...
Is this possible ???
OWC Component Cannot Be Create Using ASP
I have created an asp page that pulls data from SQL server and displays
on webpage in the form of Table and Chart.
I use OWC to generate Chart. It work find on my computer with Ms office
2000 installed, but when I upload my the page to my webserver, it
doesn't work with the following error message:
006~ASP 0177~Server.CreateObject Failed~Invalid ProgID. For additional
information specific to this message please visit the Microsoft Online
Support site located at: http://www.microsoft.com/contentredirect.asp.
Does anyone know how to solve this problem?
P.S. On the production server, Office Web Component had already been
installed. WSCript.CreateObject("OWC.Chart") works fine in my colleage's
vbscript file.
Create An Use Threads
tell me with some examples to how to use our own threads in asp pages. I tried to do it in usual way how we are suppose to use it in console and windows application. but the same thing will fail in asp pages. it give "nullreference" exception from unknown module.
View Replies View RelatedCreate New Folder
how can i create a new folder by using ASP??
View Replies View RelatedCannot Create ASP File
I have Windows 2000 and recently included Internet Information Services. I
then created a simple ASP file and clicked on it. The Open With dialog
appears asking me to select a program. I copied an existing ASP file,
test.ASP from another computer where it runs successfully. When I copied it
to my computer it changed to test.ASP auto file. The other computer runs
Windows XP. I am not sure is this is the issue. I verified the IIS is up
and running on my computer. Is there anything that can be done to correct
this?
Using ASP To Create DOC File ...
I am using ASP code to create a Word document on the server and all is working except for one thing: I need to be able to insert page breaks. My existing style formatting for page breaks does not seem to insert a page break into the Word DOC. Suggestions? Code:
View Replies View RelatedCreate A Jobsite
How to create a jobsite.Please help me.Is any information regarding how to proceed to create a jobsite
View Replies View RelatedCreate A Dynamic URL
I've captured some data from a form and stored it in an SQL server table. The form is passed to an action script which builds the sql statement and writes the data to the db.
I want to write a URL (http://www.mysite.com/sites/home.asp)
and store the userID at the end of the URL (http://www.mysite.com/sites/home.asp?userID=22) so when I call the URL from a web page it goes to that users page.
I'm not sure how to approach this?
Create Table
I know I can Create Tables In a database with the CREATE TABLE sql statment, but I don't exactly know the syntax of the statment.
I want to add a table with a sertin feild that has a default value, is that possible?
The syntax I know is:
sql = "CREATE TABLE tablename(feildname FEILDTYPE,feildname FEILDTYPE...)"
Are there any other parameters that I can add to the statment?