Topic profile page for Database table.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Database table.
Topic "Database table" was discussed 4,323 times on 350 sites in last 3 months
Started 22 hours, 32 minutes ago (2009-12-04 02:01:00)
by Paulm
Some javascript/style in this post has been disabled ( why? ) Hi, I've imported a S57 chart into PostgreSQL with FWTools one table includes both Points and Polygons Later on I'm trying to read the geometries but I can only get the Points and it is the Polygons I want . Whar have I missed? Kind regards, Paul Malm The print out below...
Started 2 days, 10 hours ago (2009-12-02 13:57:00)
by JimS
Following code cobbled together creates a table in a temp db. Works fine. How do I make the "RowNbr" column into a primary key (and thus create an index on it...)? Thanks.
Started 2 days, 14 hours ago (2009-12-02 10:28:00)
by DanFSD
Hello, I am using VB 2008 Professional with the SQL Sererver that is installed with it. I have a SQL datbase in my program. The database has a table with several columns on which a parameterized query is based for selecting a specific jpg file name out of 114 of them at run time. I want to add a column to this table that contains the actual jpg images, so that they are stored and retrievable ...
Started 2 days, 18 hours ago (2009-12-02 05:57:00)
by Anishnow
Hi friends I 'm having bulk data of 2000 records in a dataset and it should be inserted in to database table all at once .can anyone provide me with working code....Its very urgent
Started 5 days, 21 hours ago (2009-11-29 02:55:00)
by Pat I
I converted an Access 2000 database to Access 2007. Now when I try to insert object and link a bitmap file in the table, I get an error saying "Can't open database at this time. It may not be recognized by your program or the file maybe corrupt." On occasion, I have been able to get the insert to work for one record, but if I try to do more than one record, it get the error. Does anyone ...
Started 6 days, 14 hours ago (2009-11-28 10:14:00)
by seewinpgm
Hi, Am developing website using Sharepoint server 2007. I want to store the data in the database. Instead of storing the data in database i decide to store it in the List. Is it is good approach, and also is it is easy to fetch a record from the list later because the records in list growing day by day, and also the data are frequently updated. Moved by Mike Walsh MVP MVP , ...
Started 6 days, 23 hours ago (2009-11-28 00:56:00)
by krAzyk
hello friends, m repentant if this issue come earlier...well i have surf google a lot to get related my issue bt not able to found the gud way..!! so m putting my question here... in my application thr is one page with gridview. in gridview thr are 3 columns and data coming from databse table..& each row had edit,delete linkbutton which is redirecting to another page.. ...
Started 1 week ago (2009-11-28 00:02:00)
by sshade25
I am trying to insert some data into my postgresql database table using an html form and a php script. The problem here is that when the script is run, it does not insert data into the last two coulmns and also it would insert a 0 into the third column. but when i run the query directly on the database using this sql INSERT INTO crops (crop_id,crop_type,crop_name,cultivation_yrs, local_...
Started 1 week ago (2009-11-27 16:53:00)
by dariuc
i have a database table set up in the following way: owner: person who is using the entry on this line slot1: an empty slot slot2: another empty slow on done to slot30: what i am trying to accomplish is ... I'd like to add a word into an empty slot. I would need to loop through the database to first find a value that says "empty" (which is the default) I'm at a ...
Started 1 week, 1 day ago (2009-11-26 03:40:00)
by user11943485
I have in my JSF page an inputListOfValues which is from a viewObject to get list of id.I want that when I choose an Id from the liste I get all informations in inputTexts.Then I change what is writen in inputTexts and commit.So how can I do that?
Started 1 week ago (2009-11-27 08:52:00)
by Ben8765
Hi, I would like to get the record count of a table in an external database (using the name of the table in the loop of the current database). What I've tried (doesn't work): SourceDbCount = DCount("*", "[GOOD_DATA_SAR_Recovery_Tracking_db.mdb].[" & rs!Name & "]") The procedure (**** is where ...
Started 1 week, 1 day ago (2009-11-26 01:44:00)
by vampyjoker
Hi, I have a vbscript written to read a txt file into database. Now, I would need to compare the database records that I had created with a live database record. Both database table has the same fields. I would need to check every records and updates the live database with the changes in the one I had read from the txt file. Any codes for comparing these 2 database then updates ...
Started 23 hours, 25 minutes ago (2009-12-04 01:08:00)
by wthrman
I have a large, single table database that keeps track of daily rainfalls from over 7000 locations around the country. This means that for every day, the year,month,day and station name are repeated. The database gets bigger each day and performance is being badly affected more and more (not surprising). I do a lot of SQL querying with the data. I know I could archive some of the older records ...
Started 3 days, 4 hours ago (2009-12-01 20:26:48)
by arkinsokin
Oook so, I am trying to read some data from a table that I have inserted into the wp database. My table is called "mytable", and has a unique primary field of "id". //I have experience with php/mysql, but never in wp. So I could be slow at first.. I want to get a row based on a variable $currentid, Here is my try at it: $myresult = $wpdb->get_row("SELECT * FROM $wpdb->mytable WHERE id = $...
Started 1 week, 1 day ago (2009-11-26 11:22:00)
by Maf Fereydouni
i have this format in my Contact Number column of table in database my numbers arranges like this for example +639228449586 which 63 is the country code and 922 is the first initial number of the mobile network provider and lastly the last 7 digit 8449586 is the ending number of the cellphone number. now my question is how can i populate them in 3 textboxes? i have this event in listview that ...
Started 1 week ago (2009-11-27 10:03:00)
by Viswa Bala
Hi Experts, I'm using SQL Server 2005... In my Database, some tables are getting deleted automatically.... Please advise me to Secure my Database such that Users to be given rights to edit the Database tables/fields but they should not able to delete a table... Waiting for your valuable reply... Regards, Viswa Bala
Started 6 days ago (2009-11-29 00:02:00)
by sshade25
Sorry Dormilich, but line 10 has to do only with my database connection. I dont have any error on line 10. Postgresql does not accept a separator comma or semicolon, it only accepts space in between the strings. The database connection portion of the script which is from line 4 to line 14 runs perfectly okay and report success in connection. My problem lies on line 21 which i dont quite get...
Started 5 days, 6 hours ago (2009-11-29 18:07:00)
by djjjozsi
your problem is very similar when somebody wanted to store comma delimitered values in a field. You cannot handle the values without hardcoding functions to reach them. If you need to make a simple search for non empty slots, your SQL query would be too long without keywords. You cannot filter duplications in easy ways. If you are interested in a better design just tell us. before you ...
Started 4 days, 13 hours ago (2009-11-30 10:41:00)
by SharePointFrank
...you can have both, database & SharePoint list. If you let the data originally in the database, you can connect a Sharepoint list to this database table very easy: More information: http://www.layer2.de/EN/PRODUCTS/Pages/SharePoint- Business-Data-List-Connector.aspx Cheers, Frank
Started 1 day, 7 hours ago (2009-12-03 17:31:00)
by philipose
Sathyaram, I was away for a few days. Here is the verion and fix pack information. hbuhydpf@usvh2euap2c:/home/hbuhydpf=> DB2level DB21085I Instance "iuiap01" uses "64" bits and DB2 code release "SQL09014" with level identifier "01050107". Informational tokens are "DB2 v9.1.0.4", "s080122", "U815768", and Fix Pack "4a". Let me do the search as your suggested. Thanks Philipose