[select] Forum Topics

hi now a days im doig sql n im using oracle 9i for this. now a days my instructor teaching me about select command but im not able to use it on oracle 9i because i didn't create anything, so please can any body tell me that am i going …

I have a 2 tables that I want to select in a weird way but I'm not sure how to join them, should I use inner join or join left or group by etc... [CODE]//my desired out come employee_id | training_name ---------------------------- 1 | training a | training b | …

I have a page where I need to show a number of form input fields depending on what number is selected in a select menu. I have a sort of solution but is is messy and involves too many fields. I need to show up to 15 text input fields; …

I was just wondering if there was a more optimal way to add dates to mysql if I had a drop down for each field. This is the code I use to format the dates [CODE]$date_hired = format_date($_POST['month_datehired'], trim($_POST['date_datehired']), $_POST['year_datehired']); //I have 3 dropdowns in my form, 1 for months, …

Hello all, i have a question regarding a mysql populated selectbox, i managed to fill this with data from a table, but now i want to show the selected value from another table ( with the same value of course). here is my selectbox now: [CODE]<select name="project" class="selectbox" tabindex="1"> <?php …

Hello, I am working with form having multiple tabpages. I need to set the focus on first textbox of all tabpages. I tried to declare the following when the form loads, but only txtbox1.select() is working. Private Sub frmMaintab_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load txtbox1.select() 'First …

Hi, I am pretty new to web development so bare with me. I have a simple problem that I have been trying to solve it for a while now. I have 2 select boxes in a form that when the first select is changed the 2nd select will populate from …

I need to make a form with a few options could be radio or drop down, ex a, b, and c.. and when one is selected I would have a if command that would give you another set of options like if option "a" is selected then in the same …

Hello, So here is the story: I'm trying to select from two diferend tables ( bank_wire and visa) [CODE]CREATE TABLE IF NOT EXISTS `bank_wire` ( `id` smallint(6) NOT NULL AUTO_INCREMENT, `method_name` char(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Bank wire', `checked` smallint(1) unsigned NOT NULL DEFAULT '1', `commision` char(255) COLLATE utf8_unicode_ci …

I need help with the following query, i will be so thankful if anyone can help me please. I have two tables in database: Table1: [CODE] Column1 Column2 Status smith john 1 jack smith 0 julia rob 1[/CODE] Table 2: [CODE] Column1 Column2 thomas lewis scott smith john evans lopez …

I need a help with selecting the rows in a table depending on the [I]status[/I] in previous table. [B][COLOR="DarkGreen"]Table1[/COLOR][/B] [CODE]Column1 Column2 Status Smith Alex 1 Smith Mark 0 John Smith 1[/CODE] I have second table with 2 columns. I want to select only those rows which have ANY of the …

Hi all, I have a pagination script that works great apart from one last thing I require some pointers on please. The help i need is with the SELECT query - currently the select query works, but i am bringing back all records, I am trying to bring only certain …

I am currently writing code to populate a select tag with all the hours of the day. I recently rewrote a function that will populate a temporary select tag based off a time passed in as an argument and then return the temporary select at the end. When I attempt …

Hi There, I have been scouring the web for an asnwer on something I would have thought was quite common. Any help would be greatly appreciated. I have a database which contain job ads/ I have one table "dbo.tbl_jobadvert" which contains the ad itself and another table "dbo.tbl_jobFiles" which contains …

Please someone can help me. I need a function which just returns the number of rows from known table. I tried it like: [CODE] CREATE FUNCTION getRows ( @id int ) RETURNS int AS BEGIN DECLARE @rownums int SELECT Count(*) FROM dbo.MainData where id=@id RETURN @rownums END [/CODE] But it …

Hi all, I want to create a function in c# which receives a paramater (name of a field from a table in oracle) The function will have to return the distinct values of the specific field.I don't know how to insert the parameter into the [I]select distinct(parameter) from table [/I] …

I am making a simple unit converter, and wanted the user to specify the number of decimal places to be displayed for the results. The user selects which conversion they want to perform from another combo box, and I have a select case to decide the calculation needed. Eg. [code]Select …

hi, i have the following table: +------------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+---------+----------------+ | IpAddressesID | int(11) | NO | PRI | NULL | auto_increment | | PhysicalServerID | int(11) | NO | | NULL | | | VmID | int(11) | …

Hello, I have two cfselects set up so that selecting an option in one populates the options of the 2nd select. It works perfectly on my local environment, but when I test it on our QA server, it gives the error: "Bind failed, element not found: sltBiz" where sltBiz is …

hi all im looking to use a select mysql query - but im trying to query the database against a users logged in sessions. I have the sessions working correctly but I am unsure how to included the session data in my sql select query. here is my users session …

Hello! =) Please help me with this! =) This is my last one to my diploma work! =) If the user enters a number in the textfield, than JS should set the selection in the textarea to that line. Empty lines are changed to " \n" coz I like for-in …

hello and thank you in advance to anyone who can help me with this problem. I've scoured the internetz for a while trying to find a solution to what must be a common question, but I can't find anything that relates to what I am trying to do. I have …

I have a table in Access with multiple foreign key fields. I would like to populate this table from Excel with SQL. Hardcoding values works fine: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES (x,y,...)[/CODE] Nesting SELECT statements like this fails: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES ( (SELECT f_key_x …

I'm hoping to get some help with sorting database results based on the results themselves. I have two tables in this example, one being 'product_category_lookup.table' and the other 'products.table'. The 'product_category_lookup.table' holds data which tells the website which products are associated with which categories. The reason I have a lookup …

I am writting a query in SQL Developer. I have a field in the table that holds a timezone. I need to set the query to use that timezone. Any ideas? Here's the query I have so far: [CODE]select to_char(dateoftransport, 'MM-DD-YYYY') as "Date", dispatch_id as "Dispatch, vehicletype as "Dispatch Type" …

Hello everybody! I've wrote a very simple echo server, based on a book about LInux socket programming example and it works just fine. My only problem is that i want to use select() function to handle several connections at one time. I've read lots of reference concerning that function and …

hi... i m trying to get values of more then one select box on same page.. i am showing list of all users with select box..so per user there is one select box... i want to get the value of all select box...which is select or not select... here is …

Hello everyone I have a problem using a "search" statement in mysql, using c#, here is my code: [CODE] private void btnBuscar_Click(object sender, EventArgs e) { SearchBook(txtBuscar.Text); } private void SearchBook(string bookID) { String connStr = "Server=localhost; Port=3306; Database=biblioteca;Uid=root;Pwd= -----;"; DataTable dt = new DataTable(); const string query = "SELECT …

Hi and thanks for letting me post my question here. I'm trying to create a select statement based on the following conditions, but first, let me visualize the tables. These have been created to give you an idea of the content of the tables but are not the actual values, …

[CODE]<select name="splace" onchange="eval(this.value)"> <option value="javascript:show_loc('1');">Chennai</option> <option value="javascript:show_loc('2');">Coimbatore</option> </select>[/CODE] In the above code, in the option the value property is given as a javascript. Since in IE the onclick function doesn't work I've placed onchange in the select and then given the javascript in the option value. Now to save the …