NEW LISTINGS  HOT LISTINGS  TOP RATED  EDITOR PICK  ADD A LISTING  UPDATE A LISTING  GET RATED  UPGRADE A LISTING
  HOME     MY ACCOUNT     POWER SEARCH     REGISTER     MEMBER LIST     SUGGEST CATEGORY  

Average Visitor Rating: 0.00 (out of 5)
Number of ratings: 0 Votes

Visitor Rating

Importing a text file to an Access database
35287 Importing a text file to an Access database http://www.aspjunction.com/articles/importtext.asp Learn how to import the contents of a text file (.txt) when using MS text or OLE DB Drivers wont do! We will be using the FileSystem and TextStream objects for this lesson!

For the purposes of this article we will be using a text file delimited using the "|" symbol. Here is the contents of the text file we will be using - info.txt.
ASP > Tips and Tutorials > Database-related May 3, 2007 ASP Junction send email to ASP Junction

Write a Review   Add to My Favorite   Refer it to Friend   Report Broken Link  



Other links owned by this user
This PHP app will translate any BBcode on a page to HTML readable by a browser. It is useful if you want to build a forum system.
Category:

Free program to update your website from local files. PHP FTP Synchronizer traverses the tree structure of the source directory recursively and updates the file on the website, by replacing the files which were modified.
Category:

Learn how to create clock with hands that rotates unusual, quickly, in wrong way - "crazy". To create this lesson, you don't have to use any Action Script.This animation is simple and it is for peopel who opening flash for the first time and they don't have a lot experience.This is very cool and practical animation which you can use it wherever you like. You will also learn how to rotate clock hand, how to convert it into a Movie Clip Symbol, how to use Free Transform Tool (Q) and more.
.
Category:

We are handing out GPL versions of the PHPauction script. There is no charge for the downloads, and there is a framework in place for user support.
Category:

Upload multiple files at once to your server. This is a basic script and is meant as a building block, no security measures have been taken for this version.

Simple installation
Easily integrates into your website
Simple layout allows you to customize with ease.
Category:

cACL - Control Access Levels is a component for joomla that makes it possible to set access control to joomla Backend, to any menu items: content items, components, modules and mambots! Using cACL you can define the access level (allow, hide, restric) for the user who needs to have access in the Joomla backtend for accessing
Category:

This page will generate the code needed to password protect a directory or selects files within it on your site via .htaccess. It encrypts the desired passwords, then outputs the corresponding codes to put inside your .htaccess and .htpasswd files.
Category:

AceGallery is a easy to use, file based, low cost, gallery component / control. To use it, simply drag and drop the component from the toolbox, give the input directory path, specify some basic properties and you are good to go!
Category:

EasyJobPortal provides you with all features you need to setup your own job portal ecommerce website on your own domain name. Our support team will install the script on your server and then you can start earning revenues easily. It is as easy as 1 - 2 - 3...
Category:

Clickitz sets you free from the typical, time consuming way of making money online. Commonly when someone wants to make money online it involves a lot of work and research. It can consist of finding wholesale products to resell, choosing the ones you think people will like, putting up your own money, storing the products, building a website that securely accepts credit cards, receive the orders, package the orders, go to the post office and ship the orders. Now with Clickitz you can get the end result of making money online without taking up much time, and best of all it can be done from anywhere!
Category:

This sample uses Chart object from OWC library to resize any image and convert the image to a specified format (.jpg, .png, .bmp, .gif...). The image is placed to the chart using SetTextured property, which can load any image file from a disk. Then you can use border property to set some frame around the image (or left the frame blank) and export the picture using ExportPicture method to a disk or get the picture as a binary data for BinaryWrite using GetPicture method.
Category:

Open (calendar.php) in any text editor and start editing! You may use the code any way you like, customize and see what you can do with it. It plugs in very easy to any application by just including the file.
Category:

Performance is the key requirement of any application. One of important technique which helps in the performance of application is Caching. Caching is the process of storing frequently used data on the server to fulfill subsequent requests. Reusing pages from memory is much faster than re-creating pages every time they are requesting. Caching increases your application's performance, scalability and availability. In ASP.NET, caching is implemented as an HttpModule that listens to all HttpRequests that come through the ASP.NET worker process.
Category:

Right(str, n): Returns 'n' number of Characters starting from the Right of the string(towards the left) 'str'.
Note: Use "Right" and not "right"(lower case) while calling the function.
Category:

Have you ever wanted to make an image upload and display script, but thought it would be hard? Well, actually uploading files with a form is actually really easy. In this tutorial I will show you how to upload an image, display file information about the image and if the image is a jpeg display it. This is a fun piece of code for beginners to play with and could be the basis of a larger image gallery script
Category:

High paying keywords are not the keywords that have high CPC. There are many keywords in Google Adwords system, which have a high CPC, but no Advertisers bidding on them. Relying too much on the CPC can lead you to many Fake high paying keywords. High Paying Keywords refer to those keywords on which the advertisers bid madly, and are ready to pay (more than average) per click to anybody who fetches them the target traffic. Keywords are the search phrases that belong to a specific industry. For example, "Student loan" belongs to Finance or Loan industry. Some industries are highly populated with Advertisers and competitors while others are not. And those keywords are called High Paying Keywords.
Category:

Thanks for stopping by. Lil' CMS is the simplest CMS that has been written ever: it takes only a few minutes to setup and use, requires only a little knowledge of FTP and HTML on webmaster's end and doesn't require any FTP or HTML knowledge on user's part
Category:

NMDeluxe is an advanced, news and blog management system. Based around PHP, NMDeluxe is the perfect solution for your news publishing and blogging requirements. A unique advanced templating engine alows you to edit every aspect of your news, from comments, to user messages. NMDeluxe also features an advanced administration interface to manage posting via an advanced WYSIWYG editor.
Category:

Create your online games site.
Category:

Other links at ASP > Tips and Tutorials > Database-related
This is a topic I've seen covered by others in the past but never in enough detail to satisfy me. This technique is extremely powerful and can yield huge performance gains over non-cached queries and therefore deserves more attention.
Category:

This one's like a double whammie! Welcome to the world of hard core SQL Server stored procedures and to the NextRecordset method of ADO's recordset object... Before we go on, this requires SQL Server. WON'T WORK WITH ACCESS.

That said, the goal for this example was easy... Get a list of all current tables in the database created by your's truly, get a list of dependent stored procedures for each table and do it all in a stored procedure! Easy...

There are basically 2 parts to this example. The calling application (a VBScript class called SQLServerTools) and the SQL Server stored procedure: sp_Admin_ExampleTablesDependencies (included with the class). The VBScript class is easy and contains only 1 method. That method is a great example of how to use the NextRecordset method of ADO to capture a second (or 50th) recordset returned by a procedure. For example, did you know this was valid SQL:

"SELECT * FROM table1;SELECT * FROM table2;"

Well it is, SQL Server knows that this statement should produce two separate and distinct recordsets however if you execute that and don't use NextRecordset, you will only get that first RS back. The stored procedure I wrote to do all the work is the second part of the example. That procedure returns (2 * num of tables) recordsets which is variable and based on the number of tables found in sysobjects for your particular db. Bottom line, that procedure always returns more than 1 recordset.

Right now, as you read this, I estimate that the procedure returned as many as 30 recordsets that were looped through with NextRecordset... But that's not the real magic. The class only exists to call the procedure and work with it's results. The stored procedure itself does all the work.

I've commented both the app and the stored procedure to the max but I'll give you an overview of the stored procedure... The stored procedure uses a cursor to loop through the records of a recordset returned by the system table: sysobjects. The process used is almost the same as using ADO to manipulate a recordset but right in the db itself... this means huge speed bonus and, by writing a stored procedure, all that logic is forever contained within and isn't spilled out into the class where it doesn't belong.

So anyways, while the procedure is looping through each table returned by sysobjects, it's simultaneously calling the system stored procedure: sp_depends. sp_depends is a handy function that returns a recordset of names representing every stored procedure that references the entered table! sp_depends can be used on any object, not just tables, but that is another discussion for another day...
Category:

You can test the demo for dynamically dependent dropdown lists here:
http://www.jamesfarrow.com/codeexamples/Double_Listbox_Populated_From_DB/
Category:

Searching a data base to display hyperlinked summaries that can be clicked on to display detail data provides an excellent way to navigate through your data. The following example will search our test input db of names from our example on Database Input and Display which contains last name (lname), first name (fname) and unique id (unique_id a counter of all names as they are added to the db). The user will can search the first or last name and click on any of the results to reveal the detail data (the unique id, which is all the data we have in this db) all in the same active server page. Note: The db on the server contains data primarily created by users of CodeAve.com, as a consequence some of the data contained in the db may be questionable.
Category:

We can use several providers to open DBF files usind ADODB. Basic way is to use ODBC data source (DSN or DSNless), there is several samples published on web. But how to open DBF files without ODBC? There are two other OLEDB providers, using which you can work with DBF files. One of them is Microsoft.Jet.OLEDB.
Key property to work with DBF files is "Extended Properties" - there is no much info about this parameter in documentation. This parameter has similar meaning as connect parameter in DAO OpenDatabase method. First work is to open connection to DBASE IV files:
Category:




Main Category
178
2033
792
284
174
1802
1113
905
1157
7350
70
898
59
2185
172

Join Mailing List
Joining mailing list will entitle you to receive occasional emails informing you of news and updates to the site and any special offers that may be of interest to you.



Top 10
Directory Statistics

Links: 19151
Categories: 1275
Registered Users: 697
Mailing List Subscribers: 2042
Unique Outgoing Hits: 221988

Pagerank Statistics
PR 10
2 site(s)
PR 9
9 site(s)
PR 8
37 site(s)
PR 7
291 site(s)
PR 6
828 site(s)
PR 5
2014 site(s)

PHP News