I'm uploading a CSV file to mySQL from ColdFusion with the following mySQL syntax:
#location# = http:/localhost:8500/development/uploadedfiles/contactlist
<cfquery datasource="myDatabas...
Hello,
I'm having a very new problem. I have been using mySQL for a while, and this is the first time this has happened. I'm on a MAC OSX 10.5.7 and everytime I get going, building a table ...
Hello, I am trying to create a very simple stored procedure in MySQL that creates a database. I want the name of the database to be passed to the stored procedure as a parameter. I have tried ...
Can you make a selection based on an index. I probably already know the answer to this, but I want to check.
Let's say that I have the 3 columns:
first_name
mid_name
last_nam...
Hi,
I've got a table 'products' and 'brands'. Each product entry stores a 'brand_id' which refers to the id of the brand stored in the table 'brands'.
When I want to receive information ...
When entering fields manually in a new table, after each correctly-constructed field the cursor on the next line is ->
If I enter a line with the wrong syntax, the cursor on the next line b...
hi
i have a statement attached that i trying to work out. what i would like it to do is only display results if the `custref` field is not blank or NULL. The code below seems to capture the s...
ok I have a query on a several million row table that is taking at least 30 seconds to run! I have an index on the goodDate col and I also have an index on the tagName col. I did an explain ...
How do i integrate Liferay Portal, Alfresco DMS and Intalio BPMS?
Thanks...
I use a large database with a lot of different information in more then 100 tables.
And it is growing.
At certain moment it becomes inconvenient for developers and I want to split informatio...
I've stored my dates in my SQL database as varchar(10), and I would prefer to keep it that way if possible. (Btw, I'm querying from PHP.) How can I query SQL to return a range of dates like:
I have two MySQL databases on two different servers. The data structures mirror each other.
I want to copy all the data from Server A and insert it into Server B. Upon success, the copied...
I have a MySQL table with 37 fields in it. My Import file has 10 fields that are there all the time, the next 27 can be there sometimes and sometimes they aren't. I am trying to find a way to ...
Hi Experts,
Ive attached the following code.
I do not know why its creates a duplicate of the backup folder. Please advise.
rgds,
Kenny
hi,
I have a csv file with huge data, i need to convert it to mysql datatable. Can I do it? If yes, help me to do it.
Thanks in advance.
HI THERE ,
WHATE IS THE EASY WAY TO IMPORT DATA FROM TXT FILE INTO TABLE IN MYSQL DATABASE i USE LOADER BUT DOSN'T WORK WITH ME
THANK YOU IN ADVANCE
Hi.
I am trying to work on a 3 tier application. I have created a set of Types Datasets by dragging and dropping MySQL tables into a Dataset.
I have also written code to fill the datasets, ...
Hi, My website has a custom defined 404 error handling page.
If the url is invalid or if the page doesn't exists then Im redirecting to my 404 error page
and Im cleaning up the session. Wh...
Hi All,
Please find database schema below:
Here user is related to business and country table using "relation" table. In "relation_details" table relations with
country and business ar...
Hi,
I was a bit afraid of signing up, but wow - the answers on this board are absolutely fantastic, so I signed up and hopefully someone will be able to answer my question as well...
I h...
I have a table with columns of : meta_id , post_id Descending, meta_key, meta_value,
i need to mass edit the meta_value column where the meta_key value= podPressMedia
Here is the part ...
Could someone review my MySQL code? I am trying to create a search function that searches by song title. Currently it is not returning any errors but it is not returning any search results e...
Whats the best way to do Addition in MYSQL. So if i have field "Amount" and i want to ADD to it with an insert.
So AMOUNT is currently 5.23 and i want to ADD 1.48 to it and make the new val...
I want to order results so the longest result is first. The result with the most characters/bytes should come first.
I am trying to query from my macro and get an "Out of Memory" error during hte rs.Open from this code:
Set conn = New ADODB.Connection
conn.Open "DRIVER={MySQL ODBC 3.51 Driver}" _
& ";S...
