New Member contest: Win a free iPad
Click here for all the details. Good luck to everyone.

Answer Question   |  February 7, 2011  6:34 PM
Database, DataCenter, DataManagement, Developement, Exchange, Linux, Lotus Notes, Mobile, Network connectivity, Oracle, SAP, Security, SQL Server, VMware, VoIP, Windows

QMF results display as Excel sheet (line feed characters within data fields)
When displaying QMF (V8.1) Query Results as an Excel spreadsheet, the Line control X’0A’ characters within the data fields are causing: fields to split (multiple fields) where the where the LineControl characters occur and, the field and record to be continued [strong][em]on the following Excel row[/em][/strong]. I’ve tried the replace comand Replace(T.T_Task_Desc , X’0D’, ‘ ‘).  It is sucessfull in replacing [...]

Answer Question   |  April 5, 2010  4:45 PM
Excel 2002, Line Feed, QMF

Value too Long in Microsoft Access
this is a hypethetical question.. Using MS Access you enter the last name of a student, and you recieve an error message stating that the value is too long for the field. What are your next steps?

Answer Question   |  July 30, 2010  9:40 PM
Microsoft Access

automatically populate field sequentially from list
I created a form for assigning incoming projects to employees. I have a main table that includes the majority of the data relevant to the project and I have another table with just the employee’s names, work unit, and an auto id field. The main table also has the employee’s name and work unit. I [...]

Answer Question   |  April 8, 2010  6:25 PM
Database

MySQLi and PHP problem with code
Can someone please tell me what I’m doing wrong with this particular line of code. echo "<td colspan=3>{$Row['areaCode'] . '-' . $Row['prefix'] . '-' . $Row['lineNumber']}</td></tr>"; I know that the concatenation operator is the . ‘areaCode’ ‘prefix’ and ‘lineNumber’ are all fields in a table within an SQL database. any help would be appreciated. Thanks [...]

Answer Question   |  April 9, 2010  10:02 PM
Concatenate, Database, MySQL, PHP, table

Simultaneous Query from Multiple Tables using Crystal XI
The report I’m currently attempting to write needs to pull data from two separate tables (linked via a third). Easy to do, especially as the report is specific to the linking value. However, I need to be able to sort the data in the two tables together. To clarify, the Abbrev field in one table [...]

Answer Question   |  March 30, 2010  11:21 PM
Crystal Reports, Crystal Reports XI, Data sorting

MS Access 2002 Previously updated fields revert to previous values
I have a single user application where I update a status table through VB code using DAO. This particular table has 1 record and 66 fields. As part of the processing, two of these fields are updated after which the table is closed. Later in the processing, I update a different field again for this [...]

Answer Question   |  March 30, 2010  8:24 PM
Access 2002, Database issues, Microsoft Access

Ajax based multiserver GUI for MySQL?
I am looking for Web 2.0 product that allows me to manage multiple MySQL servers at the same time. I did found one proct that seem to do the job, but I would like to compare it with some other ones! (the product is located at http://novaquantum.com )

Answer Question   |  March 30, 2010  7:32 PM
Ajax, MySQL, MySQL admin

Creation of array for input of data
Hi, I am using access 07. I have created an input form (forms.Base) with an input field of source_code. Below this there are options for other fields to be updated in a record set. There would be multiple entries in the source_code field, seperated by ‘;’. There would be a maximum number of 10 entries [...]

Answer Question   |  March 29, 2010  1:08 AM
Array, LOOP statement, Update records, VBA

passing array as parameter to stored procedure in mysql
how to passing array as parameter to stored procedure in mysql?

Answer Question   |  April 9, 2010  6:53 AM
MySQL, MySQL Query Browser

Calculating drive volumes and data usage on servers
Ok i’m a newbie.  I need to calculate drive volumes and data usage on about 75 Sun and HP servers to obtain planning data for a complete update and conversion to NetBackup for all servers. How can I calculate Total Disk Space and Disk Space used without having to add separate directories for every directory on every server. I just need the Disk Space total and [...]

Answer Question   |  March 29, 2010  1:35 PM
Database servers, Disk space, Drive Volumes, Server capacity planning, Server Data Usage, Storage

Get your FREE ITKnowledgeExchange.com sticker
Be proud to show off you are part of the community with your free ITKnowledgeExchange.com sticker. All you have to do is answer a question and email me your handle and address and we will get one out in the mail to you. Allow 4-6 weeks delivery. Even if you have one already get one [...]

Answer Question   |  September 1, 2011  3:15 PM
CIO, CRM, Database, DataCenter, Domino, Exchange, Linux, Networking, Oracle, SAP, Security, SQL, SQL Server, Storage, Virtual Server, VoIP, Windows

Case Statements SQL
I’m running a query that returns a specific status code. However, within my query that specific status doesn’t always exist and I get a null value. I would like to return another status when that is the case. I can’t seem to get the case statement to work.

Answer Question   |  March 24, 2010  2:15 PM
CASE statement, SQL

How do i recover the DB from suspect mode in sqlserver 2000?
I have a database that went to suspect mode in sqlserver 2000.How do i recover the DB from suspect without restore the DB? 

Answer Question   |  March 22, 2010  4:15 PM
Database, SQL Server 2000, SQL Server 2000 Suspect Mode

ODBC Error Message Windows Server 2003
ODBC error:   ”OLE IDispatch exception code 0 from Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified..”

Answer Question   |  March 22, 2010  3:19 PM
ODBC, ODBC drivers, Windows Server 2003

Large table in ASE 15.0.3
Hello - I’ve got a process that loads 56million rows daily (via bcp) into a table, maintaining this data for 30days.  Our company is too cheap to pay for semantic partitioning so i’m wondering if anyone has any ideas on how to make queries respond in a semi-timely manner.  There’s one date column, and two other [...]

Answer Question   |  March 19, 2010  8:21 PM
Data Tables, Database, Database query

database querying question SQLite
Hi I’m setting up an SQLIte database within my C application that will be used as an intermediate stage in converting filetypes. My design tries to keep data normalized – for example, i have an Entity table, and in that table each entity has an integer type. There is another EntityTypes table with a string [...]

Answer Question   |  March 17, 2010  5:29 PM
C, Database, Design, efficiency, SQLite

How to Export a MS SQL Image column to a file.
I have pictures stored in a Ms Sql table in an image data type column. I want to be able to write the image(which is a JPG to a file. Is there a function in MS SQL 2005 or is another tool necessary?

Answer Question   |  March 17, 2010  3:36 PM
blob data, Image databases, SQL, SQL 2005

create a procedure
i want to create a procedure it should be able to audit any change done in the database ie. drop/delete of schema tables. the procedure should be able write audited data into a remote server machine inaccessible by the system manager/dba.

Answer Question   |  March 17, 2010  6:24 AM
DELETE statement, DROP, SQL Developer

Connecting C++ to Microsoft Access
how do you connect visual c++ to the ms access database.

Answer Question   |  March 15, 2010  1:49 PM
C++, Microsoft Access, Visual Studio