456 Topics
|
|
Hi everyone, I am new to RichTextBox control in VB6 I wanted to select the entire line/row in the RichTextBox, where currently the cursor is. How should I do it ? The code should be paste in command button 'cmdSelect' Thanks in advance :) |
|
Hi thought i'd try here see if anyone can help solve this quicker. First off we have a email database. The main table is the email data, all unique rows per email address with a unique id. eg. emailid,email 1,email@example.com 2,email@example.co.uk Next we have another table which logs the data … |
|
Hi, I have a query which retrieves the most recent end_date of a contract. It works when i enter it into a cmd window but not inside my actual script as when i do a var_dump it shows as NULL. I don't understand why it works in one but not … |
|
Hi, The following code is working without errors: [CODE] <table> <tr> <td>Booking No.</td> <td>Driver Id</td> <td>Time Booked</td> <td>From</td> <td>Pick Up Time</td> <td>To</td> <td>No. of Passengers</td> <td>Distance</td> <td>Cost</td> </tr> <?php $stmt = $dbh->prepare("SELECT * FROM Booking WHERE cust_id = '$username' "); $stmt->execute(); while($row = $stmt->fetch(PDO::FETCH_ASSOC)){ echo "<tr><td>".$row['booking_no']."</td>". $row['driver_id']."</td>". $row['time_booked']."</td>". $row['pick_up_dest']."</td>". $row['pick_up_time']."</td>". … |
|
I have a simple JavaScript question. I want a drop down selection so that when you select a certain option is shows the value of the option in a div. So for example: [CODE]<select> <option value="select-1">One</option> <option value="select-2">Two</option> <option value="select-3">Three</option> </select>[/CODE] So lets say that option one is selected, then … |
|
Hi, I have a table called BookTitle that holds book information. I have an SQL statement that lists all books that have the same value of a book called 'Northern Lights'. The code works but what I want to do is to exclude 'Northern Lights' from the result. This is … |
|
Good Morning, I need some example with SQL plus code on various SET operation. But the query have to be with SELECT keyword. For example I am giving a code: [CODE]Create table student (s_id number(4), sname varchar2(10),constraint pk_sid primary key (s_id),blood_gp varchar2(4)); create table location(l_id number(4),location varchar2(20),constraint pk_lid primary key(l_id)); … |
|
Hi, I want to use javascript within my php file. The three drop down boxes involved are: [CODE] <select name="year" width="10"> <option value="<?php echo $curYear ?>"><?php echo $curYear ?></option> <option value="<?php echo $curYear++ ?>"><?php echo $curYear++ ?></option> </select> <select name="month" width="10"> <option value="01">01</option> <option value="02">02</option> <option value="03">03</option> <option value="04">04</option> <option … |
|
hi, i need to empty all the divs whic has an id like 'bkoption' eg : my html code is like this [CODE] <div class="subsubsubmenu" id="bkoption1">some content</div> <div class="subsubsubmenu" id="bkoption2">some content</div> <div class="subsubsubmenu" id="bkoption3">some content</div> [/CODE] so when i trigger an on click function i need to empty all of … |
|
Hi everyone! I've been looking for a solution, but i just can't find it anywhere... Ok, so the problem is: i have a database which looks something like this: user_id product_id score 14 . 235 . 79 23 . 235 . 32 53 . 665 . 21 14 . 235 … |
|
Hello.. i have a table named Tuition with fields: TuitionNum,TotalFee,Fine,levelNum,SchoolYear,DateCreated,Removed,DateLastModified,UserID I inserted record successfully but when i'm trying to display TotalFee using this code, [CODE] myConnString = "server=localhost;" _ & "user id=root;" _ & "password=fiancee;" _ & "database=anneclaire" SQL = "SELECT TotalFee FROM Tuition WHERE levelNum='" & TextBox1.Text & "' … |
|
Hi guys, Used this forum a bit today to find answers for a bit of scripting that I'm attempting. It's been 5-6 years since I last did anything like this, so bear with me. My question is; why does this generate results from Dec 12 2011 and not from Dec … |
|
Hi Everyone- We are building a database that needs table(purchaser) to check table(paypal) for a matching telephone number. Table(paypal) has 'purchaser telephone' as PK and table(purchaser) has 'purchaser telephone' as FK. I can insert and see the data in both tables, but running a select query returns an empty result. … |
|
my table has 2 fields, both are Keys. I save similar items in that table , like if 2 items are similar but have different Ids (in another table) I use this table to know that they are similar. so if items 1111, 1112 are the same and 1000,1002,1004 are … |
|
Dear All, I got a query where I would like to select the clientName from tblClient but with condition that this clientID does not exist in another table call tblCDSValidity. I tried like this but it failed. [CODE] SELECT tblClient.clientID, tblClient.clientName FROM tblClient,tblCDSValidity Where tblClient.clientStatus='a' And tblClient.clientID!=tblCDSValidity.clientID ORDER BY tblClient.clientName … |
|
It makes since that, when working with javascript, document.getElementById() can't find the Id of an object that hasn't yet been added to the DOM, however when I nest document.getElementById() in a function and call it after the object has been created, document.getElementById() still can't find the object. is there a … |
|
Hi everyone, well I have trying to do an elevator simulator, wich have to includo the panel with the floor, available floors, and a button panel with available floors and button up, down, but I dont understand is how to use the timers for up and down, because I vague … |
|
Ok I have a project and I pretty much have no idea what I'm doing. Our project is to make some simplified POS software, in our case, for a restaurant. The form I am currently working on is where you pick food items and add them to a listbox which … |
|
I have a problem making a select tag in php code dynamic. I'm creating a website (homework) using php and connecting to an oracle database which has all the info needed. Each agency has a list of vehicules. I created a select option tag for agencies and for vehicules. I … |
|
I have tried this : [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers left join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] this [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers inner join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] error is : Subquery returned more than 1 … |
|
Hi, I want to insert and select the data from the same table.I am using following query to insert and select the data from the same table. However, I am not able to insert the data. Is there any method to do this? $sql=mysql_query("INSERT INTO users (name,ref_no) VALUES( '$name', (SELECT … |
|
I'm an old Access programmer trying to get something I use there frequently to work in PHP/MySQL. I want to look up data in a database and then have that appear as the value in a select statement on an update form. The issue is selecting a new supervisor for … |
|
Dear All, I have data coming into my db at quite a high frequency. Once I recieve the data I have many different db operation (select, update)checking and one final insert. Before inserting I will check it exist before or not? The problem at times the similar data comes apart … |
|
this is my first code in php. i am trying this off a tutorial i saw-- i am getting error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN products.products_id=products_description.products_id' at line … |
|
IS this Correct or Please help me to find error, i cant solve that how to see record on my form Dim Slec As New SqlDataAdapter Slec.SelectCommand = New SqlCommand("SELECT Name'=" & txtname.Text & "', CNIC#='" & txtcnic.Text & "', F_Name='" & txtfname.Text & "', College='" & txtdept.Text & "', … |
|
Good day, I have a problem here: is it possible to put an input field into option such as this?[CODE]<select> <option><input type="text" value="aa"></option> </select>[/CODE] (This is not working, any suggestiuon on how to refine it for it to work?) Any help will be appriciated. |
|
Hello, I'm using MySQL for a database containing 1 table with 10 columns. The point is to get a view of a few columns and use it in a web application So, I need 2 columns from this table - Pad(varchar) and Sequence(integer), then I create 8 views like this: … |
|
I want to know that "how to show hidden fields when a user selects a particular option in the html form" I want the fields to be hidden first,then when the users selects: Option A- Particulars fields which have I will create for this option must be displayed. If Option … |
The End.