Hi, I've created a JSR-268 portlet for Liferay which uses services to interact with a database. I can deploy the portlet without problems or errors, but the table defined by the services is not created! I get no "table not found" error when I test the portlet. I get no errors at all! The table just isn't there in the database. I've fou...
How to get list of tables (objects) from Entity framework model (edmx)? In LinqToSQL model, it's easy context.Mapping.GetTables(), but how in EF.. ...
In my Delphi 2009 application I need to check if a field exists and if it doesn't add it during application execution. I have figured out the test for the field, but cannot get a field to add. I tried this var fld : TStringField; begin if not ADOConnection1.Connected then ADOConnection1.Open; fld := TStringField.Create(tbl...
How can I create a table in which I can add rows and columns dynamically? How can I make cells of that dynamic table editable? I.e. I should push Edit Command button and write texts or numbers in the cell. ...
Hello, I'm trying to join two tables. The first table has a list of 11 items which are 'site_names' with an auto id field of 'id'. The second table that I want to connect has an auto id field of 'desc_id' and another field of 'descriptions'. This second table currently has 3 rows of data that I want displayed only for id 1 in table 1. ...
Hi, I'm working on VS2005 and have tried using MySQL's ODBC to connect to a database. The problem is that when I get to the part of choosing which tables to use, there are no tables and the only selectable thing is a View, which has no name and is null (of course something like this doesn't really exist in the DB). I tried adding a Table...
Hi, I am in dilemma situation, and do not know which one is better. Lets say I have 100++ (or more) games on my website. I want to store highscore for each game. Should i store all the highscore in 1 table or each game has its own table? Compare: 1 table: 1 table contains a lot of rows(data). Every user play different game will submit ...
hi i ask subsonic for a table in my database it returs the table and all other tables connected threw foreign keys, cant i stop it bringing back all the extra table info?? here is my code: [WebMethod] [ScriptMethod] public List<DealEquipment> GetDealEquipment(Guid DealID) { List<DealEquipment> dealEquipmentList = new List<DealEqu...
Hi I would like to put the input of a multi-valued string parameter in SSRS into a table, so I can join onto it, instead of using an in (@variable). I know how to do it in a proc, but I want to do it in SSRS itself, as sending it through to a proc limits it to 8000 characters. Thanks ...
I am working on a page with several dynamically generated tables where the original developers used approximately the following logic: <table> <tr>...</tr> <asp:PlaceHolder ID="ph1" runat="server" /> </table> In the code behind: // Do lots of stuff HtmlTableCell cell = new HtmlTableCell(); // set cell text, formatting, etc ph1.Co...
when you stretch your table in tinymce you get this <table class="opbouw" style="width: 725px; height: 170px;" border="0" cellpadding="0" cellspacing="0"> however I want it to be overruled because all tables must be 100% width for printing else its looks crappy. can anyone tell me how to overule it so the table is 100% when printing...
Hi, How would I go about imposing a restriction on the number of HTML table columns when querying the database. For example, I have a MySQL table with the following values: myTable: id color 1 red 2 blue 3 green 4 pink 5 purple And when I run my query, instead of showing all rows in tra...
I am wanting to drop a column from a table in my SQLite database, and it seems there is no support for dropping columns with ALTER TABLE. Currently, I am using CREATE TABLE AS to create a new temporary table (minus the column I don't want) from one of my existing tables. I planned on dropping the original table and renaming the temporary...
Have basically the same problem as this - text has a background color set and is in a table cell. Text background color is only behind the text, and does not fill the entire table cell, which it should. The solution is normally to set a bgcolor on the table cell. Difference is that this occurs in many places throughout this particular w...
Hi! I'm trying to implement a mini toolbar under a NSTableView like I see in a lot of OS X applications, but have no ideia about which widgets to use to get the final result. As an example, take a look at the following screenshot from Mail.app: What is the best way to implement buttons like that? (add, config, remove, etc) ...
I have noticed a lot of companies use a prefix for their database tables. E.g. tables would be named MS_Order, MS_User, etc. Is there a good reason for doing this? The only reason I can think of is to avoid name collision. But does it really happen? Do people run multiple apps in one database? Is there any other reason? ...
Hi I have a little peculiar problem that I currently solve using a table, see below. Basically, I want to have two divs take up 100% of the available width, but only take up as much vertical space as needed (which isn't really that obvious from the picture). The two should at all times have the exact same height with a little line bet...
I am implementing a contest system in which the user has to choose the correct answer of multiple questions. Each week, there is a new set of questions. I am trying to find the correct way to store the user participations in a database. Right now I have the following data model: Participation Week +--------------+ ...
I'm trying to split a table in two views depending on whether the field "Date" is today or not. I have tried using WHERE DATEVALUE(table.Date)=DATE(), but I get an error at saving saying that the last ) has wrong syntax. I tried adding a group by, but apparently everything after the ) gives me the same message about wrong syntax) Am I ty...
I'm trying to use Dojo (1.3) checkBoxes to make columns appear/hide in a Dojo Grid that's displayed below the checkBoxes. I got that functionality to work fine, but I wanted to organize my checkBoxes a little better. So I tried putting them in a table. My dojo.addOnLoad function looks like this: dojo.addOnLoad(function(){ var che...