172 Solved Topics
Remove Filter
|
|
|
|
I have spent a lot of time on this question, namely, how to programatically use a PHP script to send a PDF document to the printer without launching the Adobe print dialog that results from using arcord32.exe (the adobe reader). PHP has some useful classes for creating PDF's, i.e., the …
|
|
|
Well if you were like me and Python is your first language. You are trying to learn programming and many people suggested that learn Python as a first language. You take their advice, your download Python and get all set up. Maybe you take a tutorial or two in order … 
|
|
|
I am banging my head again, and appologise if such a qestion has been posted and answered - i searched and could not see any results matching my question. I have a datagridview1 full of data, one column has a date and another a qty. datagridview1 Date Qty 2015-11-05 | … 
|
|
SELECT blabla FROM a INNER JOIN b ON a.a = b.b Is what I have. However I'd like to sort the results DESC by ID. I'd like to select last [`variable` x 10] of items sorted by ID DESC. Variable provided by PHP (I'll sort things out, I just need …
|
|
|
I think this is called "foreign key" and "local key" ? I have a table `users`, these users have `rank`. It's an `int`. There is a table named `rank`, this table has field where hexadecimal string is placed `FF0000`. Is there a way to `SELECT * FROM users` and `SELECT …
|
|
|
Hey ! I'm looking for sql 'like' command help.... I had mysql database and it had settlement table. On that table there is column named 'settlement'. In the settlement column there are so many amounts..... Now I want to find recors '0 values' Can anybody help me ? 
|
|
|
Hello everyone. Please help me. Select box <select> is not working in phonegap app only on gingerbread. It works on iOS and Adroid ice cream sandwich + jelly bean. I use jquery 1.9.1 and iscroll 4.2.5 and phonegap 2.3.0. Does anyone has any idea why would it work in ics …
|
|
|
I'm making money lending system. On that I use mysql database. I want to find customer's who skipped their daily instalment. I try this code. But It has error. ***Prveious code:*** SELECT l.loan_id, l.custormer_id,custormer_name FROM loan l JOIN income i ON l.loan_id = l.loan_id WHERE l.loan_id NOT IN (SELECT loan_id …
|
|
|
I'm trying hard with displaying details from a selected option in a drop down list for my project. I have a drop down list which is populated from a MYSQLi query. I want the user to select an option and the values associated pulled from the database and displayed to … 
|
|
Hey guys please help me with my code, I want to disable select drop down if $stat=a, this is my code. Thank You! echo "<select name='name' id='name' 'if ($stat =='a'){ echo ('disabled');}'>";
|
|
|
for example I have this html code: <select id="mySelect"> <option value="0">apple</option> <option value="1">orange</option> <option value="2">banana</option> <option value="3">tomato</option> </select> 1-how can I select ` <option value="2">banana</option> ` (by passing the value attribute to selector function)then click on it with javascript with out using jquery 2-Is there any way to select this …
|
|
Hi folks. I'm having a problem with VS2010 where suddenly one of my projects is displaying the warning "The referenced component 'System.Data.SQLite' could not be found". All i can find about it in my search is a problem with building both x86 and x64 applications, but my project is only …
|
|
|
Hi I am newbie to PHP. I just wanted to create a registration page for students. In that page I've populated checkboxes for students who wants to enroll more than one classes. Everything got done. But I'm stuck with the final phase of this idea. I just wanted to save …
|
|
|
<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> Product: <select name="s_product"> <option value="">Plz select product</option> <option value="1">TV</option> <option value="2">Fan</option> <option value="3">Light</option> </select><br/><br/><br/> </form> <?php if(isset($_POST['s_product'])) { $product=$_POST['s_product']; $sql = "SELECT * FROM `data` join product on data.p_id=product.p_id WHERE …
|
|
heres my function for select the font: CHOOSEFONT ShowSelectFont(HWND hwnd=GetForegroundWindow()) { CHOOSEFONT cf = {sizeof(CHOOSEFONT)}; LOGFONT lf; cf.Flags = CF_EFFECTS | CF_INITTOLOGFONTSTRUCT | CF_SCREENFONTS; cf.hwndOwner = hwnd; cf.lpLogFont = &lf; cf.rgbColors = RGB(0,0,0); cf.lpLogFont->lfStrikeOut=FALSE; cf.lpLogFont->lfUnderline=FALSE; cf.lpLogFont->lfHeight=-MulDiv(12, GetDeviceCaps(GetDC(hwnd), LOGPIXELSY), 72);//change font size _tcscpy(cf.lpLogFont->lfFaceName, "Arial" ); //we must include tchar.h if(ChooseFont(&cf)) { …
|
|
Group, I've got a complex If/Then statement that may require the use of "Select Case". However I'm not familiar with how "Select Case" actually works. Needless to say, I'm not sure if you can use it within an "If/Then" statement. Here's what I need to do: If row > 7 … 
|
|
|
Hello Everyone, it seems that I cannot see the wood for the trees.... :-) I am having problems with this line of code... StateSQL = "select * from petrol_table where fueldate >= " & "'" & M12S & "'" & " and fueldate < " & "'" & M12F & …
|
|
|
Hello All, I have a table with column_name as USERNAME where USERNAME is VARCHAR2(20) and I want to display it as **"USERNAME@email.com"**. How to write the select query for this. **QUERY**: SELECT USERNAME AS EMAIL FROM STUDENT Thank you.
|
|
how can i select a particular child node for example when i click on a node it is selected so that if selected node= TreeView1.Nodes(0).Nodes(1).Nodes(4) then messagebox.show("node selected") end if
|
|
|
**Hello, please help me on this. I want to select from these table,** table name: User | Register_date | --------------- | 2015-02-04 | | 2015-02-04 | | 2015-02-14 | | 2015-03-14 | | 2015-04-04 | | 2015-04-14 | table name: Reservation | Order_date | Amount | ----------- | ------ | …
|
|
i cannot select from two tables but i have the right code here it is: $sql = "INSERT INTO ticket (senderName, receiverName, `Date`, ticketID, match1, match2, match3, match4, match5, match6, match7, match8, match9, match10, match11, match12, match13, match14, match15, match16, tip1, tip2, tip3, tip4, tip5, tip6, tip7, tip8, tip9, tip10, … 
|
|
|
hi guys.. i always got this error in vb6.. here's my code [CODE] '########### Variable declaration ########### Dim conn As ADODB.Connection Dim rs As ADODB.Recordset '########### Variable initialization ########### Set conn = New ADODB.Connection Set rs = New ADODB.Recordset strUserName = txtUserName.Text strPassWord = txtPassWord.Text connStringSQL = "MySQL ODBC 5.1 …
|
|
|
I am trying to get the text (not value) of a selected item in a select box <option> and display it elsewhere on the page. I have to admit im totally new to this so im going to need an explanation on plugging in a JQuery file... Thanks!
|
|
|
Hi I have this query: `SELECT SUM(`KN`) + SUM((COALESCE(`EUR`, 0)))*7.5 FROM log WHERE `KN` IS NOT NULL and `EUR` IS NOT NULL` And it retunrs 0 SUM(`EUR`)* 7.5 should be zero but SUM(`KN`) is 60. I am not shure what I am doing wrong here, I want to add numbers …
|
|
|
hi there , i would like to use the select statement in this event and not sure how to proceed... Private Sub TreeView1_AfterSelect(sender As Object, e As TreeViewEventArgs) Handles TreeView1.AfterSelect Dim NS As String = "" Select Case NS Case "Monday" If NS And e.Node.Text = "Monday" Then MessageBox.Show("The user …
|
|
I wanted to chain 3 selects and I got it working using this code. http://jsfiddle.net/FJFFJ/1/ The issue I now have is, how do I fetch the selected values from each dropdown in PHP? For example, the above creates 3 select boxes when the page is opened. When I click on …
|
|
|
I currently wish to write a query to duplicate data in database while modifying one column. First of all, my database structure: table code CURCD NOT NULL VARCHAR2(3) CODE NOT NULL VARCHAR2(2) ITEM NUMBER(1) DSCPT VARCHAR2(20) The unique idx is the curcd,code,item. What I wish to achieve is duplicate data …
|
|
|
I’m trying to patch a routine and I finally found the problem. I am given the following string: [code] $query = "SELECT title, DATE_FORMAT(event_date, '%Y-%c-%e') AS event_date FROM $dbTable WHERE event_date LIKE '$year-$month%'"; [/code] In the month variable at the end, for the months January through September I am returned …
|
|
|
I am looking for help to write a query. I have a database with an ID a Date_Field and a Description. I want to find out two things What Date_Field and Description and Description are the same? {duplicate records} [code] SELECT * FROM TIME_TABLE t1 WHERE EXISTS ( SELECT * …
|
|
|
hi people how do I select a specific row in a data grid view to be updated. the row contains item number, item name and price. thanks
|
The End.