456 Topics

Member Avatar for
Member Avatar for horizondesai

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 :)

Member Avatar for horizondesai
0
2K
Member Avatar for Biiim

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 …

Member Avatar for smantscheff
0
285
Member Avatar for magicmarkuk

Hi I am having a problem with my syntax for the following code: What I am trying to do is: 1. Check if sticky = 'y' then give a value of 1 2. If not then check whether announcement is 'y' then give a value of 2 3. If not …

Member Avatar for magicmarkuk
0
157
Member Avatar for BenzZz

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 …

Member Avatar for BenzZz
0
112
Member Avatar for BenzZz

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>". …

Member Avatar for BenzZz
0
86
Member Avatar for jonow

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 …

Member Avatar for stultuske
0
220
Member Avatar for blivori

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 …

Member Avatar for hfx642
0
2K
Member Avatar for moneypro

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)); …

Member Avatar for ChrisPadgham
0
211
Member Avatar for BenzZz

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 …

Member Avatar for AleMonteiro
0
154
Member Avatar for Virangya

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 …

Member Avatar for Virangya
0
560
Member Avatar for newinphp

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 …

Member Avatar for diafol
0
110
Member Avatar for archelle

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 & "' …

Member Avatar for adam_k
0
206
Member Avatar for rahulroshan

Hi , I want to copy the selected fields, eg:SELECT * FROM table1 where flag='1'; to another table ,table2 can anyone plz help me

Member Avatar for pritaeas
0
96
Member Avatar for geaclaesson

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 …

Member Avatar for geaclaesson
0
560
Member Avatar for MitchellJ

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. …

Member Avatar for MitchellJ
0
3K
Member Avatar for 54uydf

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 …

Member Avatar for pritaeas
0
192
Member Avatar for newbie14

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 …

Member Avatar for newbie14
0
169
Member Avatar for deshazer.jad

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 …

Member Avatar for deshazer.jad
0
161
Member Avatar for jdiaz1302

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 …

Member Avatar for Reverend Jim
0
586
Member Avatar for lp10731

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 …

Member Avatar for lp10731
0
178
Member Avatar for mkab

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 …

0
171
Member Avatar for bilal_fazlani

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 …

Member Avatar for bilal_fazlani
0
253
Member Avatar for nikki05

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 …

Member Avatar for nalini@121
0
140
Member Avatar for martymaven

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 …

Member Avatar for martymaven
0
185
Member Avatar for newbie14

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 …

Member Avatar for newbie14
0
258
Member Avatar for craign924

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 …

Member Avatar for shadowcrawler
0
153
Member Avatar for Hardosh Kumar

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 & "', …

Member Avatar for Hardosh Kumar
0
179
Member Avatar for lps

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.

Member Avatar for Agarsia
0
251
Member Avatar for pepyrs

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: …

Member Avatar for pepyrs
-1
202
Member Avatar for akshayphp

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 …

Member Avatar for svilla
0
172

The End.