Search Results

Search found 32492 results on 1300 pages for 'reporting database'.

Page 898/1300 | < Previous Page | 894 895 896 897 898 899 900 901 902 903 904 905  | Next Page >

• how to add some checkboxes in stackPanel at runtime?

  - by sillytweety

  Hi all, I am a new silverlight user and struggle a bit with the coding. Could anyone please help me. What I am trying to do is create a list of checkboxes in a stackpanel on my application at runtime. The amount of checkboxes is determined by the amount of classnames in my sql database. I am using vb

  Read the article

• How to count NULL values in MySQL?

  - by abbr

  I want to know how can i find all the values that are NULL in the MySQL database for example I'm trying to display all the users who don't have an average yet. Here is the MySQL code. SELECT COUNT(average) as num FROM users WHERE user_id = '$user_id' AND average IS_NULL

  Read the article

• Item of one combobox should not come into the other

  - by syedsaleemss

  Im using c# .net windows form application. I have a database with some tables.I have two comboboxes (A & B). I have populated a combo box A with column names of a table using sys.columns. Now when i select an item in combo box A ,combo box B should be populated with the same items except the selected item which was selected in combobox A .

  Read the article

• How to make db structure for multiple input in MySQL and PHP

  - by bob

  Below is my current structure for MySQL database id | item_name | item_files ------------------------------------------ 1 | Item A | file1.zip,file2.zip,file3.zip 2 | Item B | file3.zip Example I create simple form to fill up Item Name and Multiple upload files then store it to db. Question :- How to design the db structure for accept the multiple files? There have a way which I don't want to use explode, implode to get the file1.zip file2.zip file3.zip

  Read the article

• What is the best way to create derived properties

  - by user342788

  I have a datamodel with to-many to-many relations. Using the example of employee database let say the entity division is related to department which in turn is related to employee. The employee has an attribute salary. How best to have a attribute at the level of division which is derived from the salary attribute. For example average salary or maximum salary. I would need those attributes to sort the list of departments.

  Read the article

• How to get the ID of the last insert.

  - by James Jeffery

  I have an application and around 20 accounts are created per minute (on average). I need to implement a new feature which requires the ID of the last insert. I am using PDO. The question is, lets say 5 users create accounts at exactly the same time. Will it return the ID from the database for that users profile that was just created, or will it return the last insert? If you get what I mean.

  Read the article

• Is there any control that take System.Drawing.Image object and view as image ?

  - by Space Cracker

  I return array of images ( System.Drawing.Image[] ) from database and i want to show them in datagrid or datalist .. Can any tell me how to do that ?

  Read the article

• Oracle Extended Stored Procedure with C++

  - by BeginnerAmongBeginners

  I am currently adding Oracle 10.2.0. as a viable database to a product. The product originally allows connection to SQL Server and I have found some extended stored procedures. Is it possible to produce similar extended stored procedures for Oracle with C++? If so, how do I accomplish this? Example code would be much appreciated.

  Read the article

• How to implement callback functions inside classes (PHP)

  - by sombe

  I need to use a class callback method on an array inside another method (the callback function belongs to the class). class Database { public function escape_string_for_db($string){ return mysql_real_escape_string($string); } public function escape_all_array($array){ return array_filter($array,"$this->escape_string_for_db"); } } Is this the right way to go about that? (I mean, in terms of the second parameter passed to array_filter)

  Read the article

• Find column that contains a given value in MySQL

  - by shuby_rocks

  Hello all I have a table in a MySQL database. I am given a value that occurs as a cell value in that table but I do not know which cell is it i.e. the row and column of that cell. What is the most efficient way to find the column to which that value belongs? Thanks in advance.

  Read the article

• How to get the duration of the video uploaded ?

  - by Holicreature

  i'm using ffmpeg to convert videos to desired formats and to generate the thumbnails.. I want to find the total duration of the video to display in the main page along with the thumbnails.. Can i use ffmpeg to find the duration when its being uploaded and store them on the database.? Is storing the duration in db is necessary or else is there any other method?

  Read the article

• Signs that a SQL statement is dangerous

  - by Matt

  Hi, I want to develop a function in PHP that checks how dangerous a SQL statement is. When i say dangerous i mean, certain symbols, characters or strings that are used to get data from a database that the user shouldnt see. For example: SELECT * FROM users WHERE userId = '1' can be injected in several ways. Although i clean the params, i also want to monitor how safe the query is to run. Thanks in advance

  Read the article

• Linq To Entities

  - by JkenshinN

  This has probably been answer already but I am trying to return the primary key after inserting a record to the database. Does anyone know how this is accomplish after the record has been created?

  Read the article

• PHP array question.

  - by TaG

  How do I show the dates number format next to its name in the array using PHP? So that the number format is saved in the database and the month name is displayed? Here is the php code. $month_options = array("Month", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");

  Read the article

• How do i insert 1000 times in one statement? with SQLITE?

  - by acidzombie24

  I want to fill this table with 10000000 values but first i want only 1000. I tried this in sqlite database browser but 3 isnt inserted unless i drop everything after it. But more importantly i dont know how to have num go from 1 to 1000. create table if not exists test1(id integer primary key, val integer); insert into test1(val) select '3' as num where num between 1 and 1000

  Read the article

• Dictionary Application

  - by Joy

  Hi all,I want to develop an iphone application that needs an english word dictionary. Can you people suggest me any link from where i can have that database containing a reasonable number of english words with their meanings and example sentence. Thanks in advance

  Read the article

• Can't create/write to file (Errcode: 22)

  - by magdmartin

  Quite new with SQL I'm looking to export some data from a MySQL database into a csv file. I'm working locally (localhost). Here is my SQL statement: SELECT DISTINCT * INTO OUTFILE 'C:\Users\Martin\Downloads\result.csv' FROM provider, location, provider_has_location WHERE provider.idprovider = provider_has_location.provider_idprovider AND location.idLocation = provider_has_location.location_idLocation LIMIT 20 MySQL return the following error: Can't create/write to file 'C:UsersMartinDownloads esult.csv' (Errcode: 22) Thanks for your help.

  Read the article

• SQL updating a column in a table

  - by tecnodude

  Hi, I have the following table in an access database id VisitNo Weight 1 1 100 1 2 95 1 3 96 1 4 94 1 5 93 Now row 2 and 4 are deleted. So i have... id VisitNo Weight 1 1 100 1 3 96 1 5 93 However what i need is... id VisitNo Weight 1 1 100 1 2 96 1 3 93 What is the SQL query i need to accomplish the above? thanks

  Read the article

• How do I mysql select with aliases from another table?

  - by Rob

  I'm working with a CMS system where I cannot control database column names. And I've got two related tables: Table: content +------------+----------+----------+----------+----------+ | content_id | column_1 | column_2 | column_3 | column_4 | +------------+----------+----------+----------+----------+ | 1 | stuff | junk | text | info | | 2 | trash | blah | what | bio | +------------+----------+----------+----------+----------+ Table: column_names +------------+-------------+ | column_id | column_name | +------------+-------------+ | 1 | good_text | | 2 | bad_text | | 3 | blue_text | | 4 | red_text | +------------+-------------+ What I'd like to do here is select from the first table, but select the columns AS the column_name from the second table. So my result would look like: +------------+-----------+----------+-----------+----------+ | content_id | good_text | bad_text | blue_text | red_text | +------------+-----------+----------+-----------+----------+ | 1 | stuff | junk | text | info | | 2 | trash | blah | what | bio | +------------+-----------+----------+-----------+----------+

  Read the article

• technology for new webproject?

  - by elCapitano

  Hi there, i am planing to set up a new webproject which has to use a database and a model which can be presented in a browser. I looked at a lot of technologies (JSF, PHP, ..) but i could not find a free and easy framework/technology for me (in the end i prefered asp.net, but this is not free). What can you recommend me for a new webproject from scratch?

  Read the article

• List of system tables in SQLite

  - by sovanesyan

  I am trying to filter all the tables in a SQLite database based on if they are system tables or user generated ones. So far I've found out that they are the ones with the sqlite_ prefix and AllDataTypes. Has anyone done something like this? Is there a list of them? Thanks in advance.

  Read the article

• I need some advice from Experts on how to develop a PHP site with MySQL

  - by mouthpiec

  Hi, I need some advice from experts :) I will develop a website using PHP and I will use also MySQL. I bought some server space from a Virtual private server including all the service needed. How should I develop the site? Shall I develop it on my machine at home (using for example Wamp), and when ready transfer all the files to the server? If so what is the best method to transfer also the database? Thanks in advance!!

  Read the article

• Java checking connection via socket continuously

  - by Onca

  I'm developing a multiclient-server program with Java based on GUI and database. The demand regarding the program from the client side is to make sure all the time that there is a connection to the server, and if the connection is lost (server goes down/problem with socket or stream) it should be notified. In other words I need a solution for continuously checking the connection to the server. What is the best way to do that ?

  Read the article

• How to convert numbers to words in php

  - by user225269

  Is there a function in php wherein you can convert the number 12 to its equivalent in a month. For example if the mysql database stores digits and not words for dates. how do you convert the number 12 into the word december?

  Read the article

• i am using c# with asp.net and sql 2005 as backend, i want to use dropdown list cntrl in a form and

  - by kunal

  i am using c# with asp.net and sql 2005 as backend, i want to use dropdown list cntrl in a form and fetch a column in a textbox which is linked to that dropdown cntrl in the database, what coding should i use in c# for that?

  Read the article

< Previous Page | 894 895 896 897 898 899 900 901 902 903 904 905  | Next Page >