Search results for query: *

Hi All, I hope someone might be able to help me by taking a look at my regex and telling me where i am going wrong :-) I have a load of text files in the format Title: blah blah blah over one or many lines Article Body: blah blah blah over many lines I am trying to capture the content of...

Hi, I have a bunch of XSD files and a bunch of XML files can i create a database from this using some tool? I have been searching all over the internet and there is lots of talk of the other direction i.e. SQL to XSD & XML, but i want to go the other way. Any suggestions? Thanks, Jez

Hi, I am trying to automate a script that needs to run every other night. When i run it from the command line:- perl limey.cgi from within the httpdocs folder of linux webserver, all is runs fine. Then in the cron tab i have the following entry 23 1 */2 * * /var/www/vhosts/[DOMAIN...

Hi all, I have some code that works without error in FF but simply fails to run in IE. I have done some alert based testing and the AJAX function does get data from the server but as soon as i try and populate any element i get nothing, no errors or any kind of hint in IE. Here is the code...

Hi everyone, I am trying to copy files from a HSM archive. They appear as stub files but give name and size correctly. When i then try and copy it fails with 'no such file or directory'. This only happens on files that are not cached, for instance if i try and copy it fails, then i try on the...

Hi All, I am doing a select statement with 4 joins (LEFT), to produce a list of questions stored in the database. I want to list these by their Section in order to populate a form. For instance i have Section 1, question 1 = What is your name... etc. I am using order by Section, Question to...

Hi. The title of this thread is the error i get from the following sql statement. INSERT INTO Media_Cart_Items (cart_id, cart_item_filename, cart_item_filesize, cart_item_full_path) VALUES ('286', '***.WMV', (SELECT Filesize FROM...

Hi, I have the following query;- INSERT INTO media_cart (cart_name, cart_identifier, cart_owner_name, cart_xoops_user_id, cart_status) VALUES ('newcart', 'xxx', 'jondoe', '36', '1'); SELECT SCOPE_IDENTITY() AS cart_ID; When i run it in the SQL server management studio i get an...

Ok, so i have taken a look at many threads on here and MSDN about paging in SQL 2005. All seem to be working on fairly simple queries getting one or two columns. I have a query that is very large, it gets at least 15 columns from 3 tables and then adds search related items to the where clause...

Not sure if this is possible, but does anyone know where i might find some resources to make a db appear as an xml file on a unix system. I think i need the xml to be a symlink to some kind of interface or api.. but thats as far as i have got... Any ideas? Thanks.

Hi everyone, I have an MSSQL 2005 database, with some data in it, some of which is in arabic characters. Using the MS tools to manage the DB i can see these no problem. I am trying to output this data to a web page. In the page itself i am just getting ? instead of the arabic. So far i have...

Hi everyone, I am looking for a php framework to create the CRUD screens based on an existing MS SQL database. I hoped Symfony would do it, but sadly symfony never seems finished (ie. the full feature set of any given version is not completely functional, in this case, not working with MS...

Hi all, I am trying to do something fairly simple with a DB insert. I would like to run the query. If there is a primary key violation, then the data has gone into the DB already and i want to move on. The purpose of the script is to read a folder and enter some details for each file into a...

Hi All, I have a raw series of bytes in Hexidecimal that i need to 1) convert to something human readable. 2) possibly write back to this format from something readable. I know it is a description for a colour, but that is about it. Any one any ideas on what perl i need for this. Here is a...

Hi everyone. I am just looking for clarification on a scope issue. I have my perl file which is writing some XML based on some inputs. I have got a whole bunch of default values in a .pm file. For info my script is called VO_delivery.pl and my package is called VO_delivery_xml_config.pm In...

Hi everyone, I am using this module to access Apple's Plist data which is a standard way for apple software to store prefs and user data. It is all good, but makes no mention of how to output the XML again once you have done something with it. Maybe i am being a little dim, but i don't see...

I am trying to migrate some data from a database to a copy of itself but with some extra fields in some of the tables. I want to DUMP the old data and then insert it in the new one. When using mysqldump i can only do this in the form of "INSERT INTO table VALUES (list of values)" What i want...

Hi Everyone, I am trying to do this;- INSERT INTO RackData (rackNumber) VALUES (SELECT DISTINCT Rack FROM Server); I am trying to copy all the unique rack numbers from my server table to the new rack table. I could not find info on this on mysql.com and I am currently getting an error about...

Hi everyone, I am using almost identical versions of mysql (5.0.24a) and 5.0.41 I am have used MySql Administrator to backup the db needed. It has a large number of stored procedures. When i try and import it, either using phpMyAdmin or the command line, i get an error regarding the delimiter...

Hi Everyone, I am trying to make some changes and additions to an existing database. I have access to the server its running on and i have root access to the database. It is running on Solaris, so any changes made on the server have to be done at the command line or i connect with the Admin...