Re: [Phpwebsite-developers] sqlImport doesn't like ALTER TABLE commands

[Don S. <do...@se...>]

Hm I suppose we wouldn't be able to do table prefixes then.  I suppose the 
best avenue is to fix the sqlImport() function.

In researching that endeavour, I also noticed that extractTableName 
doesn't support alter table either.

I'll work on some fixin's from home if I have get some time.

Don.

On Thu, 10 Apr 2003, Don Seiler wrote:

> Is it in bad taste to have just a function to read a file and run the sql 
> without trying to validate or any of that fancy jazz?
> 
> Don.
> 
> On Thu, 10 Apr 2003, Don Seiler wrote:
> 
> > Did some invesimagating and came to the conclusion that sqlImport in
> > core/Database.php barfs on 'alter table' commands.  Mainly it doesn't seem
> > to know when one alter table command ends, so I keep getting "incorrect
> > formatting" errors.
> > 
> > I've tried to add a line similar to the "preg_match" for drop table but I 
> > can't seem to get my head around it.
> > 
> > Once that issue would be resolved, I would probably run into a problem at 
> > the end of sqlImport since there is no "alter" case in the 
> > switch($command) statement.
> > 
> > So if someone with a less fried brain wants to give it a go that would be 
> > super.
> > 
> > Don.
> > 
> > 
> > 
> > -------------------------------------------------------
> > This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger 
> > for complex code. Debugging C/C++ programs can leave you feeling lost and 
> > disoriented. TotalView can help you find your way. Available on major UNIX 
> > and Linux platforms. Try it free. www.etnus.com
> > _______________________________________________
> > Phpwebsite-developers mailing list
> > Php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> > 
> > 
> > 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger 
> for complex code. Debugging C/C++ programs can leave you feeling lost and 
> disoriented. TotalView can help you find your way. Available on major UNIX 
> and Linux platforms. Try it free. www.etnus.com
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> 
> 
>