How I can to execute a Query with field BLOB with grouping?

How can I execute a Query with field BLOB with grouping?Does have as converting BLOB to VARCHAR? ...

query date field in dbf file

Hello, everyone. How can I query date field in dbf file?I try the SQL:select * from show128 where rq='2003-3-7'orselect * from show128 where rq=date('2003-3-7')but it is failing. Do you know? ...

Oracle Appending a variable field that has the attributes of a CLOB [Diary field]

Hi, We have a custom application which resides on Oracle 9.1.2. Users enter data thru this custom application into a Diary field which resides on Oracle 9.1.2 Data is stored in a field called 'Work Log' which is a CLOB. Another user may open this record and modify the Work Log field, however I want ...

MySQL How to query without install ODBC?

Hi, I would like to know if I can use Perl to query a MySql server without the need to install ODBC on user side running the Perl script. If its possible, which Perl library can I use? ...

Offtopic: "query analyzer" for odbc datasources

I usually do sql-server programming but sometimes I also need to test and query ODBC-datasources with SQL such as Access or Progress databases. I usually do this using active server pages which I find rather obscure, and I would prefer to have a nice little program sort of like query analyzer, where ...

MySQL How to form query when field name has spaces?

I'm doing a database for a dog-rescue group, and their info is being written by Front Page to a CSV file. Finally got an import CSV to MySQL to work. But all 160 fields have field names with numbers, spaces, apostrophes, question marks, etc. I really don't want to hack into the source program to mak ...

MySQL can't query one field in table

I am not really a Newbie, but this is a bewildering situation for a seemingly simple task. I have a database with a table that has three fields. If I login via the command line. I can do a simple select statement to select all three fields (field1, field2, field 3) and display them. I can do simple ...

Oracle query says field value 1 does not equal 1 ?!

I have a table that I'm running a query on, there are two data fields that are the same data type. Let's call them Field1 and Field2.In my query I can try something like decode(Field1,Field2,'TRUE','FALSE') and it will say 'FALSE' even if Field1=1 and Field2=1, or Field1=2 and Field2=2Or if I try to ...

Paradox query reference field value in same table

I would appreciate any help with the following Paradox 12 problem. I need to reference another field value in the same table in my query but don't know the syntax. To keep it simple. Say I have a table named tbl_cost.db with fields cost1 and cost2. I want my query to display only those records where ...

Query, Concatenate, Field width limit

I have a query that has a custom field that concatenates 4 other fields into one.The custom field is being cut off at 255 characters. Is there any way to increase this field limit? Here is the custom field code:cNote: First([custom1] & " " & tcomposite.date_created & [custom2] ...

error in stored query with field name

I'm having to work on a table that has the following field name:e-mailWhat I have to do is use an updated stored query. Below is my code:tblFAWLMembers.e-mail = strFAWLEmailAccess kicks back at me with an error when I try to update a record. How do I resolve this? ...

Query againts field help

I have this table.| id | name | surnameHow to know if in the surname field are present the surname "Foo" and the surname "Bar"? (Not only Foo or only Bar, but both of them)Is there a simple query that accomplish the task? ...

Oracle Query on field by capitalization

Can anyone tell me whether there is a way to query on a field based on whether the information is capitalized or not? I would like to get a list of records with information in the field that is in capitals, one for information that is all lowercase and one with initialcaps. Example: FRANK and JOE wo ...

Help Please-Query memo field failure

Please help i'm no access whiz, just a basic database where i am trying to search a memo field within my table and and it will only bring back the word specified in a parameter query if it is the first word in the field entry. For example it will find and return "THE" in field entry " ...

117 GB Not Enough!!! Update Query 1 Field

In running this query, I get an error that says there is not enough disk space to complete the Update.I have 117 GB of free space! Just how much will it need for 1 field in 409,655 records?UPDATE tblSoCalMLS_Download SET tblSoCalMLS_Download.STREETNAME = UCase([P_OfficeName]); ...

Query : new field

A new field has been created. The database has been rebuild.The new field is ok using the unix interface (xddts).But the field is not visible when I want to create a query using the web interface.Any idea ?Thanks in advance.Daniel (Daniel.Tiberinus@tiberinus.fr) ...

Use Query result field as Query key for new Query..

Not sure if the title made it clear, but here's what I want to do: $query = "SELECT ProjID, UserID, ProjDesc, file, OrigProj, OrigUser, ProjDate FROM projects";$result = mysql_query($query);I would like to take the field 'UserID', and utilise it for a Query statement to my users table in m ...

Query one Field for Multiple Values (Array)

I have a previous query in which I return certain student_id numbers in an array called $student_id. This array could contain 10 to 30 values in it.I would then like to query a different table so that I can return the student info based on the values in the $student_id array. The values in $student_ ...

query a field with multiple values

I have a version field where the submitter can choose multiple versions. for example, 2003-06, 7.0, 7.0.1 and 7.1. so the user can pick one, two, three or four versions. How can I write a query to find the defects where there is more than one version entered? is there a count option or something?TIA ...

returning query results from ODBC

I'm using Visual Studio 2010 C++ Express and connecting via ODBC to MS SQL Server 2008 R2 Express.My question is: Is there any way I can pass some type of pointer into SqlGetData instead of an actual data type, then stuff that reference into a void pointer for the calling function to typecast/derefe ...

Oracle Query Panel field extends beyond right margin

I've a .jspx with a Query Panel. The problem is that the search field for a 500-character string attribute extends beyond the right margin; so if a user enters a long search criterion, the user can never see the entire criterion. Is there a way to force such fields to be multi-line; in other words, ...

Oracle af:query Search Field Alignment

Please find the attached screen shot. How do I align all the field .. I tried 2 options1. setting control hint display width to 80 for all the fields in VO, but the lovs length gets adjusted based on the content not on the control hint.2. tried css , set [https://plus.google.com/photos/1096670233406 ...

MySQL How do you query a field that contains comma separated value list when two of the values contain the same word?

I download an MLS database and they have one field called PROPERTYCONDITION. This field contains one or more values separated by commas. For example, it has ABOVE AVERAGE and AVERAGE as two different possible values. When I do my where statement how do I specify I want all AVERAGE but not ABOVE AVER ...

MySQL How to query a field with a "\" in the data

I've been voluteered to look after a billing database running on MySQL 4.1. I need to query the database as below SELECT * FROM `eom_invoices` where period='2006-11-30' and customercode='\customer' but the "\" is obviously a special character or reserved as this returns an empty set -yet i ...

MySQL query same field multiple times

I have a problem querying data, let's say if I have a table category / product_name 1 / blue shoes 2 / pink shoes 3 / blue shoes 4 / yellow shoes How can I query shoes belongs to both category 1 and 3? I tried SELECT product_name FROM product_table WHERE category=1 AND category=3, but I didn't get t ...

sql query analyser [Microsoft][ODBC SQL Driver]Timeout Expired

Ive got a collection of view which piece together data from varying sources and assemble it ready for a stored procedure to squirt the data into a table.This has worked fine up til yesterday when i had to amend one of the views to include a reference to another data set.Essentially the data is for s ...

Problem Query Date field

The data type that i set for the Job_date is 'date'.Somehow i face problem quering the table using the following code.PHP Code:  $stmt = "SELECT Completed FROM Job WHERE Job_Date = '23/02/2004'";           ...

MySQL query - Where Field In(Array)

I'm trying to do something that must be simple, but I just can't seem to get my query right://Prepare venue data$Vresult = mysql_query("SELECT * FROM SPCvenue WHERE Country = \"$county\"");while ($Vrow= mysql_fetch_array($Vresult)) {$VenueID = $Vrow['id'];$VenueIDArray[] = $Venue ...

How to query WHERE field = NULL ???

I've been digging for some months now (off and on) for the means by which to query for fields with a value of NULL, but haven't turned anything up yet. Till now, I've managed to improvise some other way round this, but enough already!Please, what would be the syntax?Iv'e tried ....SELECT from campai ...

how to query DateTime field in MsAccess?

I am using a table 'STDHistory' with one field(DateTime) of type 'Date/Time'.how can I retrieve records of certain date say '1/1/03/ 5:15:20 PM'. ?, If Iheve string containing specified date!My code is as,{....CDaoRecordset *rsHistory=NULL;CString sql,sDate="1/1/03 5:15:20 PM";sql.Format( ...

dataset query sum(field)

Does anyone know how to sum fields in ms access using SQL and then place it in datagridview? I have a ms access table with fields 'Points' and 'FacultyID'. I would like to know how to sum all values on 'Points' field and place it in datagridview. Also, I would like to know how to filter values from ...

Query : Select field from multiple tables at once

I'd like some help with a query.I have a database named 'base1' which contains many tables.Some of the tables have names like 'track1' , 'track2' etc... which have identical columns.I would like to select all the tables beginning with track and show the data of a specific column named 'ammount'. ...

Oracle query same field

I am looking for a select statement that gives me a list of table that has a field.For example the name "ENTRY" .Select all the tables that has field ENTRY is defined as a field. ...

MySQL How to join three tables and query for field on two tables

I have a problem where there are amounts received. These amounts are then distributed as 'saving' and 'expenses' against individuals. I need a query which will return me the list of 'amounts' returned which are related to a specific individual. Here are the basic structure to replicate the issue: CR ...

Query: One field-retrieve records that contain 1 of 3 possibilities.

I figured out my problem - really dumb mistake, but at least I finally found it. ...

Sql query where field = (ANY VALUE IN ARRAY)

I want the page to echo records that equal any values in an array.<?php$result = mysql_query("SELECT favorites FROM membersWHERE username = '$_COOKIE[user]'");while($row = mysql_fetch_array($result)){$stores = explode(",", $row['favorites']);sort($stores);}?><?php$result ...

MS Query - Oracle ODBC

I use MS Query via an ODBC driver to connect to an Oracle database.If as sometimes happens I use task manager to 'End Task' MS Query because I do not want to wait for the returned data what happens to the query request executing on the Oracle database?Does the request terminate as soon as I 'disconn ...

The decimal field's precision is too small--when making query by access

I HAVE MYSQL DATABASE (4.0.20). I LINK MY TABLES TO AN ACCESS 2002 FORM. MY AIM IS TO QUERY TABLES BY THESE FORMS. I HAVE INSTALLED MICROSOFT JET 4.0 SP 8 PACKAGE. WHEN I QUERY WITH MATCH "WHOLE FIELD" (FIND) OR "START OF FIELD" THERE IS NO PROBLEM. HOWEVER WHEN I QUERY WITH MATC ...

ODBC how implement query timeout?

Any ideas on how to implement a query timeout (if no resultset within x seconds, the query expires)? The ODBC API function to implement this is SQLSetStmtAttr with an attribute of SQL_ATTR_QUERY_TIMEOUT (MySQL 5.0 Reference Manual 23.1.16). Issuing this command is reported to succeed based on an odb ...

Append query changes my field names randomly

I have an append querey that I built with the Access Query Builder. I selected the field name from the drop down list that the builder provides along the "Append To:" row, in order to be sure that I did not mis-spell the field name. When I toggle to the datasheet view, and then return to t ...

Multiple values for value(s) field of query filter in ClearQuest Client

The query filter field in the Add/Modify Query part of the ClearQuest client says 'value(s)', but I can't find any operators or method for putting in multiple values. I know I can put in multiple queries, but I am looking up the exact same info for hundreds of defects and just want to be able to ent ...

ODBC Problems with connections

I'm writing a JSP web application. I'm using MyODBC 3.51.12 to connect to DB on Windows XP. I need to do a lot of queries looping on a part of my code. If the number of loops is low, all works fine but when the number of queries is too big I get the following error: ERROR [HYT00] [MySQL][ODBC 3.51 D ...

ODBC ADO Recordset DateTime and charset option

Found next problem, when setting value for DateTime field ODBC 5.1,MySQL Server 5 under Windows XP Pro. OS,VB6, ADO 2.8 Dim r As New Recordset r.open "select * from kogud where id=1", "dsn=mysql;charset=ucs2", adOpenStatic, adLockPessimistic r.fields("kirje_muudetud").V ...

.NET datetime field off by one hour

All my datetime fields are returning off by 1 hour (IE: 9:24:06 AM returns as 10:24:06 AM). If I query the field with Toad for MySQL it returns the correct data, If I use the ODBC connector it returns the correct data, but the .NET connector (5.2.2.0) is returning the data +1 hour. ...

MS-SQL-Server over ODBC

I have to add one field from a database to our website. I studied the code from the rest of the site and created the following lines:<?PHP$dsn="dsn";$user="";$pwd="";if (!$cc=odbc_connect($dsn, $user, $pwd)){echo "ODBC-Verbindung scheitert";exit;}/* Perform ...

ClearQuest integrated with Remedy

Does anyone know of a way of integrating a Remedy Help Desk ticket system with Rational's ClearQuest bug tracking system? I would like to send the information from a helpdesk ticket to ClearQuest when the ticket is related to a bug. Also, the reverse would be nice ... when the bug tracking database ...

PHP-Function Coding for MS-Access Query

Please find the function coding. please help me in the select statement syntax. i am able to display all records from the access database. but i want to display only the user input idno. equal to field variable in my table in access.i am using apache php4.0function Output_Entries() { /* Make the con ...

Sphinx Possible parser bug with extended @field queries

I am currently implementing Sphinx as a Phorum backend for a website which is switchingto Phorum, where it will be indexing 2,000,000+ messages. It's working well most of thetime, but some of the queries are not returning the expected messages. The type ofextended query that seems to go wrong is the ...

Sphinx field searches some optional

I would like to accomplish the following,I have a site with real estate listings where the user is able to check several optionswith check boxes and then I set the setfilters that works fine, the problem is when I'msearching the non-integer fields which I do something like this:@property_type (sale| ...

Sphinx is it a valid query?

(@first_name lam | @last_name fayland) | (@first_name fayland | @last_name lam) |(@first_name test | @last_name lam) | (@first_name lam | @last_name test) | (@first_nametest | @last_name fayland) | (@first_name fayland | @last_name test) | @firstname"fayland lam test" | @last_name "fa ...