How can I execute a Query with field BLOB with grouping?Does have as converting BLOB to VARCHAR? ...
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? ...
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 ...
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? ...
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 ...
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 ...
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 ...
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 ...
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 ...
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] ...
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? ...
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? ...
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 ...
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 " ...
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]); ...
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) ...
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 ...
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_ ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
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 ...
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'"; ...
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 ...
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 ...
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( ...
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 ...
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'. ...
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. ...
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 ...
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 ...
I figured out my problem - really dumb mistake, but at least I finally found it. ...
if (isset($_GET['add']) && $_GET['add'] == "true") {$sql_insert_genres = "insert into genres (name) values ('$name')";$query_insert_genres = odbc_exec($db,$sql_insert_genres); }What's wrong with that piece of code someone please? It's saying when the URL -- http://www.wha ...
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 ...
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 ...
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 ...
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 ...
I have a query like this:$my_query = "select * from my_table";$my_result = mysql_query($my_query);and I get the field names from this query:$my_field_name[$j] = mysql_field_name($my_result, $j )or die ("could not fetch field name ".mysql_error());with $j looping.Now I want to fet ...
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 ...
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 ...
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 ...
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. ...
Running Apache WebServer with PHP on Win2K and having the following error: "Error in odbc_exec( no cursor returned )" when running the following script:Any help would be greatly appreciated.<?phpfunction HTML_Head() {echo "<HEAD><TITLE>Processing Form</TITLE></ ...
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 ...
I'm trying to extract some data from an access database. This is my error:Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect in c:\program files\apache group\apache2\htdocs\cfm\cfm\2.php on line 35 This error i ...
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 ...