473,322 Members | 1,431 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

MySQL dump - Multiple entries/field problem

jenkinsloveschicken
I apologize for the rudimentary post, however I have a bit of a problem. I have been tasked with developing reporting for a ticketing system. Development has provided me with a rough output form of the data. Once a ticket is submitted and worked it creates separate records for the Comments field each time it is updated, however the remainder of the record is blank. Is there an easy way to concatenate these into a single entry for the comments field for an individual ticket?

Regards,
Gerald
Apr 20 '07 #1
3 1599
MMcCarthy
14,534 Expert Mod 8TB
I apologize for the rudimentary post, however I have a bit of a problem. I have been tasked with developing reporting for a ticketing system. Development has provided me with a rough output form of the data. Once a ticket is submitted and worked it creates separate records for the Comments field each time it is updated, however the remainder of the record is blank. Is there an easy way to concatenate these into a single entry for the comments field for an individual ticket?

Regards,
Gerald
Sorry Gerald need a lot more information about what's going on. Can't really follow what's happening or what you require.
Apr 21 '07 #2
Sorry for not providing more clarity. Here goes: Ticket is created. In the initial record, all of the required information is there. ie. Date, Customer Name, Issue, Comments, etc. The problem is that when the support agents "work" the ticket and update it creates a new record where there is only information in the comment field and there is no information in Date, Customer Name, etc. The backend dump output places these updated records sequentially after the initial record which opens the ticket. ie. Record 1 is full ticket information. Record 2 is blank except for new entry to Comment field. Record 3 is blank except for new entry in comment field, and so on.

Hopefully this makes more sense. What I need is a way to reference the update records(blank except for entry to Comment field) to the inital record which contains all of the ticket information.

Thanks again,
Gerald
Apr 21 '07 #3
Please close this thread. I have managed to find a fix for my problem. Thanks for the input though.

Gerald
Apr 23 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Dariusz | last post by:
I am a beginner in PHP and MySQL, and am working through a book and various online tutorials on PHP and MySQL and now stuck - installed everything on "localhost" and it all works fine. My question...
2
by: Joe | last post by:
Hey, I'm going to give some background on my situation in case anyone can point out a way around my problem altogether... for the problem itself, please skip to the bottom of the post. thanks....
7
by: Charles Crume | last post by:
Hello all; I have used dBASE, and other computer languages/databases, for years. They all have a logical field type. However, the version of MySQL used by the ISP hosting my site does not...
3
by: Mosher | last post by:
Hi all, I was wondering if there was any way that I can have a webpage with a text field that acts as a search box and when someone types even one character (letter or number) into the text field,...
1
by: ccr | last post by:
Please view in a text editor so that the columnar text lines up. I used Terminal 9pt font to compose this post and copied/pasted to my newsreader program. I am writing in the hope that one of...
13
by: Jim Hubbard | last post by:
I have a client that desires a new application for use at several stores in different cities. He wants "real time" access to all store data and the ability to continue to run locally even if the...
13
by: miker2 | last post by:
HI, I'm having trouble writing to a MySql db using python and the MySQLdb module. Here is the code: import MySQLdb base = MySQLdb.connect(host="localhost", user="blah", passwd="blah",...
7
by: Randy | last post by:
Folks: We have a web-based app that's _really_ slowing down because multiple clients are writing their own private data into a single, central database. I guess the previous programmer did...
0
by: TechnoAtif | last post by:
<?php include "dbconnect.php"; include "commonFunc.php"; ?> <!----------------------------------> <table width="80%" border="1" cellpadding="2" cellspacing="0"> <tr > <td...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.