Last post Apr 22, 2007 11:13 PM by darkknight187
Apr 17, 2007 10:26 AM|arnoldizon|LINK
I want to add or extend 2 additional columns into Ads table. Does anybody know what are the necessary files do I need to edit and line number in the scripts
in order for me to insert the data in the newly added colums?
Does anybody can help me about this? Thanks in advance for your help!
Apr 17, 2007 03:46 PM|darkknight187|LINK
There's a lot of files you will need to modify, you might what to copy your work in progress periodically so you'll have backups, just in case. I'ld start with the "classifieds_Ads" Database. and stored procedures.
I got mine to work by copying one of the originals, I think it was, "AdType" and just duplicate what ever was done with adtype do the same with your new columns. If you get stuck use the debugging tool to help you out. And the "output-formatting" file that
uses adtype is not neccessary to copy.
There was two files that got me at first, In the Databases, after you entered your new column in Ads, Expand the Views folder, and go into "ClassifiedsView_Ads" and check the check box at your new column.
And in your solutions explorer, assuming your using visual web developer, expand "App_Code" & "DAL" right click on "Ads.xsd" and click on view code, again make your changes.
Here's a tip though, the first time I loaded two new colums I was just putting them in, I'm still not 100% sure, but I think it mattered only in the "Ads.xds" you need to keep them in the same order, example.. location, new1, new2 new3. If you mix it up
a little bit you may get information uploaded to the wrong column.
If you still can't get it upload a list of what files you changed and I'll tell you which one still needs modification.
Good luck, and don't forget to mark your tag as answered if you get it.
Apr 18, 2007 04:26 PM|arnoldizon|LINK
Apr 22, 2007 11:13 PM|darkknight187|LINK
It seems a lot of people are asking the same question so I posted it over here.