actually you just generate another migration...
so you could alter_table instead of create_table or whatever. Every
time you create a migration it gets a number ie: 001_inital_create.rb
002_alter_blah.rb
and so on.
so then you can do: rake db:migrate VERSION=0 (drops all tables) or
specify a ta
Have you somehow cached the data? Are you sure the DB CF is running
against is the same as the one you are manually running against?
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
"Dissent is the purest form of patriotism."
--Thomas Jefferson
On May 21, 2007, at 6:08 PM, Greg Drake wr
Thanks Dusty, but I'm afraid I already tried that. It all came out how
I expected it to. I ran the results directly through the database and
it came out fine. For that matter, I ran the results back through the
tag and it came out fine.
Mischa, Debugging was a good idea. I never think of using t
Yes..It is a big mess.
They have an internal system for order processing.
It is a very old DOS based system that wont let them create any new fields.
People have been using this product name field for "notes" etc..
There is no consistency to how the did it either.
These are only a few of the many
There have to be some rules for determining where the fields start or
stop. Without figuring that part out all the regex magic in the world
won't help you. I can't make any sense out of that mess.
On 5/21/07, Kevin <[EMAIL PROTECTED]> wrote:
Thats why I am having so much trouble with this.
this
Does anyone out there use PostgreSQL in their apps? If so, since I have no
experience what so ever in this area, my question is (I googled for this but
all so confusing to me):
Can I somehow access PostgreSQL data remotely? Some info I found in Google
lead me to believe it could be done over tcp/
Thats why I am having so much trouble with this.
this>>> [ 5.3" CANDY HEART N/L 2DZ/DIS $24/16 ]
Is ALL in one field.
I have to seperate it into 3 fields.
(using pipe delimiter)
ITEM | EXTRAINFO | SIZE
CANDY HEART | N/L 2DZ/DIS $24/16 | 5.3''
Thanks for your fast reply.
On 5/21/07, Greg Drak
I can't even figure out how you are telling the different fields
apart. Are there spaces I'm not seeing?
On 5/21/07, Kevin <[EMAIL PROTECTED]> wrote:
I have a huge data file(10,000+ rows) that I need to import on a monthly basis.
The programmer that worked on this before me wrote some spagetti c
I have a huge data file(10,000+ rows) that I need to import on a monthly basis.
The programmer that worked on this before me wrote some spagetti code
to process some of the garbage out of the file, but now the client
wants to save the garbage into another field. The data in not
consistant enough t
You may have tried this already or perhaps the query is rather complex (it
sounds like) but:
1. make a copy of it.
2. remove all the cfqueryparam tags and replace with normal variables or
values.
3. replace the cfquery tags with code
here
4. output the actual query text so you can see what is real
: Sorry for not posting any code, but I'm thinking you have either run
: into this before or you haven't. I can't find anything online, perhaps
: because the issue is difficult to describe.
I'd suggest turning on debugging and see what SQL actually gets fired to the db?
Mischa Uppelschoten
T
Has anyone else ever run into a situation where does not
return the same records as a direct query on the database?
I have a rather large query joining 5 tables and 2 derived tables. The
'where' clause is cluttered with dynamically loaded conditions. There
are some tags that keep me from easily
way kewl, yes, curious, what happens when changes are made? Does rails
generate alters?
DK
On 5/21/07, Steven Ross <[EMAIL PROTECTED]> wrote:
This is why i like rails so much (not knocking coldfusion, just
thought I'd share a bit). One thing I don't like about ant is that it
is just executin
This is why i like rails so much (not knocking coldfusion, just
thought I'd share a bit). One thing I don't like about ant is that it
is just executing sql scripts. You don't actually write code to create
your tables.
one command: rake db:migrate
creates the tables, no sql scripts, xml or any of
I don't know if MS SQL has the option or not, but in some RDMBS you can
audit the DDL so that everytime a table or view or index is created,
altered, or deleted the system writes/appends the actions to a log file.
Then you can just run the log file against another db to "replay" the
actions. This w
ah, too manual for me for long term, we got over 30 apps. I'm looking at
using ANT, has a SQL task for this. Just wondering if anyone has played
with this approach before.
DK
On 5/21/07, Mischa Uppelschoten ext 10 <[EMAIL PROTECTED]>
wrote:
To be honest, I just load them in Query Analyzer a
To be honest, I just
load them in Query Analyzer and run them,
but you could also run them in a script (VB,
batch) using the OSQL utility.
: yes. How do
you plan to execute these scripts? :
DK: On 5/21/07, Mischa Uppelschoten
ext 10 < [EMAIL PROTECTED]>:
wrote: : : Im moving
to hav
yes. How do you plan to execute these scripts?
DK
On 5/21/07, Mischa Uppelschoten ext 10 <[EMAIL PROTECTED]>
wrote:
I'm moving to having all my MS SQL objects scripted and stored as a file
and only make changes to my db through that script. Is that what you mean?
Mischa.
: We are about to e
I'm moving to having
all my MS SQL objects scripted and stored
as a file and only make changes to my db
through that script. Is that what you mean?
Mischa.
: We are about to embark
on constructing a staging database here to
sit between: our dev and prod ones.
I have all our app code in
We are about to embark on constructing a staging database here to sit
between our dev and prod ones. I have all our app code in CVS and move it
between dev, staging, and prod servers. What do folks do with SQL code?
Sure, can store it with the app code in CVS or whatever SCM tool, but how to
exe
20 matches
Mail list logo
