|
|
Posted by Frankly on 06/19/06 17:46
"J.O. Aho" <user@example.net> wrote in message
news:4fo5n4F1ji4k0U1@individual.net...
> Frankly wrote:
>> "J.O. Aho" <user@example.net> wrote in message
>
>> what i was thinking with that new table
>> was that it could very well be that i had to delete some of the relations
>> and create new ones using that new table. I felt like anything thing i
>> did was a total guess. yes i did think of just making creations from
>> those fields.
>
> Okey, like a temp table? That could be useful. The reason I was so against
> the table was that there was no image id anywhere else and you had it
> already building and apartment relations in the apartment table.
> I do regret that I did tell my opinion in such strong words and I
> understand it was a hard blow for you.
dont regret it my friend. you had no way of knowing how i felt at the time.
even until now i didnt express myself correctly. I felt any thing i did was
a total guess or in my heart it felt like a cheat.
what i think i ended up doing was making a post with the fields and saying -
please create the relations for me. but in my heart I couldnt help but feel
no matter what relations I put it was a guess and the end result was the
same. i felt terribly guilty and no matter how many relations i looked at
for examples i couldnt figure it out to the point where I didnt feel it was
a guess. however my first quess believe it or not was just to create new
relations with the new fields. I am sorry I didnt do that because it looked
bad for me.
>
>
>> basically what i did was research my choices, see who says what is
>> easiest and who thinks what are the best. my main concern was money. i
>> didnt want to start a path only to find out that at the end i would need
>> a program that cost a few grand.
>
> *nods*
> Thats always a risk that comes, as long as you don't have the option of
> making it yourself and have the time to spend.
>
>
>
>> I finished up enough work so that I can now put these tables in my admin.
>> I am going to be adding a few new fields that I use to post adds to
>> online realestate pages. see you soon :). after that i will try to
>> create the relations.
>
> I would suggest when you have created your tables, make a "backup" of the
> database, this way you can experiment with filling test data and see that
> everything works, and if they do, you can easily recreate an empty
> database with all the tables empty and IDs starting from 1 again.
Will do and thank you.
>
> I hope it will go well for you and don't forget ALTER TABLE if you notice
> that your table is missing something after you have created it and filled
> it with test data, instead of dropping it and make a new one and then fill
> it again with data, you can make the changes directly.
> http://dev.mysql.com/doc/refman/5.0/en/alter-table.html (works the same
> way in older versions too).
>
>
>
> //Aho
Navigation:
[Reply to this message]
|