• MySQL CrossTab Query

    MySQL does not have a crosstab query. Does anyone have some code that will return a datastructure on a crosstab query?

    Carbon0 pointsBadges:
  • How to implement crosstab query in Access?

    How to implement crosstab query

    Shamu75 pointsBadges:
  • Crosstab query in SQL

    How to make crosstab in my sql?

    Tafz085 pointsBadges:
  • Equivalent for crosstab query

    Is there any function in MySQL that can create a query similar to crosstab query in MS Access?

    Sgheorghian5 pointsBadges:
  • SQL MS Access – Displaying output in a certain order

    Hi Team, SELECT mergeddatabase.Roomno, Count(*) AS Boxesscanned, Sum(mergeddatabase.Currentweight) AS RoomsTotalweight, mergeddatabase.Currentdate AS RequestedDate FROM mergeddatabase WHERE (((mergeddatabase.Currentdate) Between [Forms]![FrmDateRange]![TxtStartDate] And...

    Witsend10 pointsBadges:
  • COMMUNITY ANNOUNCEMENT: Tell us your Data Center Tales and you could win a Nintendo Wii

    Tell us your Data Center Tales and you could win a Nintendo Wii We want to hear your stories or see pictures of your craziest data centers. Your contest submissions will be published on the Tales from the Data Center blog for all to read. This two-month long contest (Oct-Nov) is your chance to win...

    ITKE352,420 pointsBadges:
  • How can I accomplish load balancing with redundancy?

    I have two links with different ISP's and both the (512Kbps) links are terminated on separate Cisco routers (2811). Currently, we are using one link. Another link is new. I want to do load sharing and redundancy between them. Right now I am not using BGP (routers are configured in simple manner)....

    NetworkingATE1,545 pointsBadges:
  • Comparison of DBMS and RDBMS

    What is the difference between DBMS and RDBMS?

    Pravi5 pointsBadges:
  • AS/400 ODBC

    Hi Our company uses AS/400 for our financial processing application. The users access the AS/400 through an emulator. They also access the application database through ODBC. They extract the data to excel sheets to create certain reports for their own purpose. Recently, one the data base files in...

    Pgsdeb20 pointsBadges:
  • How to find indicator and relative record number fields in DB2/400

    In DB2/400, even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value "Y" or "N". How to see this indicator field? How to see the DB2/400 RRN (Relative record number) field? I tried with RUNQRY...

    BibinGeorge130 pointsBadges:
  • How to connect and control the database to the webpage (using Java and HTML)?

    Would anyone know how to connect and control a database to the webpage (using Java and HTML)?

    munnyram12345665 pointsBadges:
  • QMF

    USER TRYING TO DOWNLOAD QMF REPORTS GETS ERROR IKJ56712I INVALID KEYWORD

    stewarteg5 pointsBadges:
  • How can I connect DB and input values in stored procedures using VBA

    Hi all, I'm using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me.

    Jprpvk5 pointsBadges:
  • Conversion of SQL Server 2000 to iSeries DB2 V6R1

    Hi there. We are converting SQL Server 2000 to DB2 on iSeries V6R1. We’re ok with the JDE tables and views, but are having difficulty with the non-JDE tables, views, and stored procedures. Is there a tool or something that could help us? Thank you.

    Tprusko5 pointsBadges:
  • How do I retrieve the JOB/USER/NBR for a spool file generated by a GUI program?

    I have a GUI program which HAS to run interactively that generates a spool file. The HTTP job (Which is what I correctly retrieved using RTVJOBA & QUSRJOBI) is: Job: VOI User: QTMHHTTP Number: 303484 But the job that my spool file has is: Job: QPRTJOB User: <My user ID> Number: 303384...

    Orelalaith0 pointsBadges:
  • How to write flat file data into pf?

    Hi,,  M25 is one of my flat file which is 34 char length. I want to write data from flat file to normal pf. Pf contains 3 char field which is equally devide. Now generaly to read file we have to requre key field but flat file doesn't have any key field then how i will write this pf?     

    Sms121185 pointsBadges:
  • How can we login into Sybase using an encrypted password

    Anyone can help me on this: I have a encrypted password prepared and now I want to login into the Sybase server. How can I do that?

    Malliks5 pointsBadges:
  • How to sync MySQL contacts with Microsoft Exchange

    In our PHP web application, we have a MySQL contacts table. It's integrated with the application so it allows you to add a contact, edit, etc. But it's currently self-contained. Our organization would like to integrate it with Microsoft Exchange but we've run into a few problems communicating and...

    ITKE352,420 pointsBadges:
  • Corrupt .dbf files

    Dear Sir/Madam, I am using a software bases on Clipper, i made all the entries and then I indexed. The program stopped working and closed. Since then I'm unable to retrieve the latest data from the .dbf files. Thanking you in advance.

    pliv8315 pointsBadges:
  • How do I display session ID on the web

    Hi, I am doing a login page with MySQL and ASP.NET/C#. I would like the program to run in the following sequence. The user login The login page will search through MySQL database, When it is Authenticate, it will allow the user to access. My concern now is how to you use the session ID to display...

    Blue50 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following