Wizy
|
| Posted: 02/04/2003, 2:17 PM |
|
just playing around with CC in a new project and was wondering if anyone has a tutorial on using a Txt file to store information? I see through custom string connection under Database of a project you can chose Microsoft Text Driver.
i do work with a webserver that doesn't have installed a database system (and there is no way to make them install one), and wondered how does code charge handle flat files?
|
|
|
 |
wizy
|
| Posted: 02/05/2003, 4:32 PM |
|
?
|
|
|
|
Wizy?
|
| Posted: 02/05/2003, 7:28 PM |
|
Anyone? Really, this is important. I can't believe no one has tried this? Considering many sites dont supply any type of database, figure that Flat file would be common. IN CC
Does anyone know if the MS Text Driver can only be used with IIS servers or can it be applied to apache on linux? And using PHP not ASP (for obvious reasons). And why the DB type has to be chosen when its flat file . Im getting errors when uploaded to a linux/apache server, but no errors on a apache server installed on a windows system.
Anyone?
|
|
|
|
DD
|
| Posted: 02/05/2003, 10:01 PM |
|
I also need to do a project for a client using Solaris with no current DB capability and the likelihood of getting one installed is not good as there would be a fair amount of red tape to get it past the clients I.T. department. I was thinking more along the lines of XML files to store the data. Apart from parsing it in code myself is there any way that CC can parse XML files automatically in place of relational databases?
|
|
|
|
NoName
|
| Posted: 02/06/2003, 8:05 AM |
|
Go to your loacal bookstore and read about flat-file databases in any good Perl book.
|
|
|
|
NoName
|
| Posted: 02/06/2003, 10:14 AM |
|
Do a search on Google.com for "flat+file+database" and you will get quite a few listings.
|
|
|
|
Wizy
|
| Posted: 02/06/2003, 11:14 AM |
|
Noname, obviously you think we are stupid or something.
We are looking for help in using CC to see if it does support Flat-file (wich should have been a feature in the program to start with, since many hosts do not provide a type of database).
A search on google, only shows how flat file can be used a way to store; nothing in google shows how CC can be used with flat file
If you have nothing to offer, please dont bother in replying.
|
|
|
|
NoName
|
| Posted: 02/06/2003, 11:43 AM |
|
"...obviously you think we are stupid or something."
Well judging from your responses and questions that may well be true!
-----
"Does anyone know if the MS Text Driver can only be used with IIS servers or can it be applied to apache on linux? And using PHP not ASP (for obvious reasons). And why the DB type has to be chosen when its flat file . Im getting errors when uploaded to a linux/apache server, but no errors on a apache server installed on a windows system."
-----
Microsoft drivers are for Microsoft IIS servers, period.
The Apache server running on the Win platform is a special "port" for Win-OS only (FYI, the server software hat to be recoded to run in Windows using that OS's API.)
To run on Unix/Linux you must use drivers that run in that Operating System. Sooo, visit either the Apache or a php distribution site for links to the appropriate drivers! For example with Perl I use the Perl DBI (DataBase Interface).
--------
Flat files are not true databases. They are just text files in which records are separated by a delimiters (= characters that will not be used for anything else). The major problem with text files is that they can be easily corrupted. All record locking/unlocking has to be handled via your OWN script in the server environment!!!
--------
CodeCharge was designed as Rapid Application Development (RAD) tool for databases (SQL Server, MySQL, Informix, Oracle, to name a few.
|
|
|
|
Wizy
|
| Posted: 02/06/2003, 1:06 PM |
|
"...obviously you think we are stupid or something."
Well judging from your responses and questions that may well be true!
=================================================================
That was uncalled for and insulting. Again, if you have nothing to offer dont bother in replying if you're just going to insult people with your answers.
Nothing in any documentation provided by CodeCharge says this, so one who gets this program sees that if this driver is offered, that its safe to use and CAN be used. There is nothing in the documentation to state that it can only be used with a certain OS's or servers. More documentation that needs to be addressed by the programmers. Without them knowing that there are those running into this problem, how do you expect them to solve it. At least they should provide examples for all that is provide by CC/CCS so that all avenues of site management is covered.
I know what I am doing, and have used DB's before. I've never had to use Flat file for anyting until now, which is I why im looking for answers. If you can't offer help, dont bother in replying.
|
|
|
|
Peter
|
| Posted: 02/06/2003, 2:26 PM |
|
Wizy, no offense, but the so-called "NoName" is mostly correct.
Please go to the www.yessoftware.com home page and in the product selection choose CodeCharge there is a complete description of the product's intended use.
-- The support is for RELATIONAL DATABASES. The "flat-files" are straight text only. There is no relational support there.
BTW, if you find how to do it, let us know so that we all can benefit from it.
--------- From the Product's Description -------------
CodeCharge supports:
Databases: Any relational database, including Oracle, Sybase, mySQL, Microsoft SQL Server, and Microsoft Access that you can connect to via ODBC, JDBC, or ADO.
|
|
|
|
Wizy
|
| Posted: 02/06/2003, 3:42 PM |
|
Then its something they need to add in. not supporting Flat file as well will be one of Code charge's weaknesses, especailly if other coding software do.
Im still working on it and until i get a better answer from support, i'll provide it here.
|
|
|
|
Peter
|
| Posted: 02/07/2003, 8:16 AM |
|
What other CodeCharge like software do you know that supports "flat-files"? I don't know of any that do.
|
|
|
|
feha
|
| Posted: 02/09/2003, 9:59 AM |
|
I think going back to Flat-File "database" is as going back to stone age !
(For this you won't need CodeCharge ...)
regards
feha
[www.vision.to]
|
|
|
|
|
