Question about Computers & Internet

1 Answer

Query for retrieve the data

Hi,

i have cereated a table and inserted into values for carddetails.

e.g. cardnumber=1234567891234567

now i have a problem here is

when i enter only 6 digits from the above cardnumber i have to retrieve the data


Posted by on

  • ambica Jan 25, 2008

    thanks for trying



    but i didn't get the correct answer



    from the above post i have to retrieve the data by entering the first 6 digits only



    so please help me for this query

    it's very urgent for me

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Contributor
  • 35 Answers

So, are you looking for the query statement to get this info...

And, upon entering the 6th digit, your code will execute the sql query, such as:
SELECT cardnumber from <table_name> where cardnumber>='123456'

NOTE: replace <table_name> with the name of your table.

You might have to modify the statement depending upon how your calling it.

Check out more info at http://www.w3schools.com/sql/sql_where.asp

Hope this helps.

Posted on Feb 02, 2008

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I want to save and retrieve some data from html page to excel. how to do this


remosofts,

  1. In a blank Excel sheet (or blank tab), click on the cell where you want the html page to begin placing data.
  2. From the top menu, select [Data] and choose [Get External Data] from the drop-down menu.
  3. Select [New web query] (view other options for future queries)
  4. A pop-up screen will have a few options, of course enter the html page location in the first box (Web address)
  5. You probably want to also select *The entire page (instead of only 'tables' default)
  6. Click [OK] and look at the data in your Excel sheet!
  7. You may want to adjust the options in future data retrievals.
Thanks for choosing FixYa!
-Gort.

Oct 11, 2010 | Microsoft Office Standard for PC

1 Answer

In php how to retrieve data while setting an conditon with multip


First of all, it's a Query that used in PHP. it should be like this.

select * from table_name where id in (value1,value2,value3 <---->

This will work

Jun 07, 2010 | The PHP Group PHP

1 Answer

CAN WE ENTER DATA IN TABLE THROUGH QUERY CALCULATION


Yes, you can add the resulting calculations to an existing query by using and update query, or you can create a completely new table with the results of the query in it by using a make-table query.

Oct 28, 2009 | Microsoft Office Access 2003 (077-02871)...

2 Answers

Access database was copied now no tables in dropdown list


Your version of Access may require slightly different menus and clicks than mine, but the procedure is straightforward and should be very similar to what you will need to do. Read the whole post first!

Make sure you have permission to modify the database, then go to the form (I assume the drop-down table is in a form) and go to design view.

In design view, click once on the dropdown box you are having a problem with, and a properties screen with several tabs should pop up; click on the data tab, and look at 'data source'. In the list look for 'row source type' to see if the source of your data is a) a table or a query, b) a value list or c) a field list. Most dropdown boxes use either a value list or data from another table or a query (based on a table).

Check the source of data by going down to the next line in the list titled 'Row Source' (this is the list on the data tab that popped up when you clicked on the dropdown box in design view).

If the source is a table/query type you should see some code in the Row Source box like "SELECT....". Without changing anything, click once immediately to the right of the box, and whatever source the rows are coming from should pop up--if a query, for instance, it will pop up the underlying query in design view.

You should be able to troubleshoot the underlying query to see why no data is given in the dropdown box.

Another point where underlying query or table is used: If the table was based on a query that pulls data from the records in the current database, the drop down list will be blank until new records are added so the query has something to list.

And if the source is a 'value list', the values should be included in the row source box below, separated by semicolons. If not you simply need to add them in.

If your source is a field list, go back to whomever copied the database and tell them you need help with the copy they gave you...

Sep 13, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

1 Answer

How to write a code of a combobox


Hi,

Try this code:

Combo-BOX - Abstraction With function you can retrieve the combo-box
structure with its data
<?php
function GetCombo_Where($db, $nombre, $tabla, $campo_lista, $campo_graba,
$campo_seleccionado,$valor_seleccionado,$where)
{
$query="SELECT * FROM $tabla ";
$query.=($where)?"WHERE ".$where:"";
$db -> query ($query);
$cant_registros = $db -> num_rows ( );
$string = "<select name=".$nombre.">";
if ($seleccionado=="")
$string .="<option></option>";
for ($i=1;$i<=$cant_registros;$i++)
{
$db -> next_record ( );
$value = $db -> Record[$campo_graba];
if ($valor_seleccionado == $db -> Record[$campo_seleccionado])
$string .= "<option selected value = ".$value." >";
else
$string .= "<option value = ".$value." >";
$string .= $db -> Record[$campo_lista];
$string .= "</option>";
}
$string .= "</select>";
return $string;
}
?>
hope this helps.

Thanks
Shafi

May 08, 2009 | Computers & Internet

1 Answer

Dissappearing spaces when html page handles database data


Mark, it sounds like when you are displaying the data back to check and edit the data, you are not including it inside of quotes.

example:

//query to grab example data
$query="select name,salary from employee";
$result=mysql_query($query)
or die("query failed!");

printf("<input type='text' value='%s'>",mysql_result($result,0,"name"));
printf("<input type='text' value='%s'>",mysql_result($result,0,"salary"));

notice in my example the "value" argument of the "<input>" command the %s for your variable is contained within single quotes.

Apr 04, 2009 | The PHP Group PHP

1 Answer

Conversion of nemeric value


If you just want to change the format to text in a query, you can use the Str function in your query. In MS Access, in the Field area of your query in Design View, you can type the following:
YourDesiredCharFieldName: Str([YourNumericFieldName]).

On the other hand, if you prefer to convert the data once and for all in your table, you can go to the Table Design View for that Table, change the Data Type of your numeric field to "Text", and close that window to save the changes. This will convert all of your data in that field from numeric to text permanently.

Jul 01, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Microsoft word


Dear shilpi tyagi, go to the table menu then click insert -table-then put the value of rows and columan-ok. insert the data from your keyboard as usual bye

Sep 19, 2007 | Microsoft Office Standard for PC

4 Answers

Running SQL queries on Excel


Another way to do it is to use the SQL Drill freeware Excel addin (http://www.sqldrill.com)
hth

Aug 14, 2007 | Microsoft Office 2003 Basic Edition...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

81 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...