Storing Binary Data
I've been in the process of reviewing the pros and cons of storing binary data (e.g. image files) either in blob fields in a database (presumably MySQL) vs. the filesystem of a server. I'm aware there are some concerns of security, but I'm mainly interested in performance at present.I could easily...
View Answer
| May 14 2008 3:45 PM GMT
| asked by
Chunter
Binary data, Database, MySQL
MySQL Stored Procedures with Parameters in Crystal Reports 9???
Hi,am using Crystal Reports 9 and the MySQL 5 DBMS.I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'. Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the way I...
Answer Question
| May 12 2008 11:10 AM GMT
| asked by
Les za
Crystal Reports 9, MySQL, Stored procedures
MySQL Stored Procedures in Crystal Reports
Hi,am using Crystal Reports 9 and MySQL 5 DBMS.I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'.Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the way I...
Answer Question
| May 8 2008 11:18 AM GMT
| asked by
Les za
MySQL, Crystal Reports, MySQL Stored Procedures
MySql Query
Hi Gurusi have a problem in MYSql Query Browwserthere is a table "jiuser" in "jasperserver" database. this table has a column "username". there is another table " jiresourcefolder" in the "jasperserver" database. this table has a column "uri". now i wana find out which user can access which uri....
View Answer
| Apr 7 2008 11:12 AM GMT
| asked by
Abhi Here
Database, SQL, Open source
Running different versions of MySql on same machine?
Is it possible to run different versions of MySql on the same server machine?
View Answer
| Mar 18 2008 7:37 PM GMT
| asked by
Ozzyit
MySQL, Database
Is there a server running on localhost: 3306?
Has anyone seen this error before? We've got a Windows 2003 Standard Server running MySql 5.x.x, with ColdFusion MX 7.x.x. Everytime we try to add a new MySql DSN Connection we get this error:Connection verification failed for data source: cudefaultjava.sql.SQLException: Communication failure...
View Answer
| Mar 17 2008 5:24 PM GMT
| asked by
Ozzyit
MySQL, java.sql.SQLException, ColdFusion
how to compare 2 dates == x day and delete the file
hi, do any one know how to compare the 2 dates.comparing today's and the file created date using mysql and c# here is my program but i am stuckstring ConnectionString = "server=localhost;user id=name;password;persist security info=True;database=name of database;"; using...
Answer Question
| Mar 13 2008 9:26 AM GMT
| asked by
Blue
C, MySQL
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.1. the user login 2. the login page will search through mysql database,3. when it is Authenticate, it will allow the user to access.my concern now is how to you use the session id to...
View Answer
| Feb 26 2008 9:38 AM GMT
| asked by
Blue
MySQL, ASP.NET, C
Membership login with mysql
hi, i doing a login program which will be using mysql. I would like to how do i do that, I have done a little but i am stuck half way can anyone help? protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { MySqlConnection conDatabase = new...
View Answer
| Feb 21 2008 1:36 AM GMT
| asked by
Blue
ASP.NET, MySQL, C
MYSQL/PHP based CMS (Mambo,Joomla) on the 400.
Has anyone setup one of the MYSQL/PHP based CMS (Mambo,Joomla) on the 400 yet?I use these CMS on regular Apache 2.0 servers with MYSQL 5.0 & PHP 4+ These CMS are very flexible and adaptable and I would like to use on the 400.
View Answer
| Feb 12 2008 11:08 PM GMT
| asked by
DHanneman
PHP, MySQL, CMS
Access to MySQL - How hard is this going to be?
I've just taken on a client who has been building his databases in MS Access for 14 years. He wants to put a significant amount of this data into an online MySQL application. I know it can be done, and I've agreed to help him do it. Does anyone have a feel for what it will take to get his data...
View Answer
| Feb 11 2008 11:06 PM GMT
| asked by
The Geek
Microsoft Access, MySQL, Data migration
Creating forms with PHP and MySQL
Using PHP and MySQL, I am trying to create a table form which can input multiple data within the form. When the space row provided is not enough, I want to add in another function which can help add rows in the same table. How can I do this?
Answer Question
| Jan 30 2008 5:45 PM GMT
| asked by
MarkG713
PHP, MySQL, Development
Need your help with sql joins
Hi there, I have two tables named articles and writers.articles table looks like this : article_idwriter_idtranslator_idarticle_textwriters table looks like this:idwriter_namedate_joinedA few of the articles could be translated but mostly self written articles. The writer_id and translator_id...
View Answer
| Jan 20 2008 8:33 PM GMT
| asked by
Oorsolli
MySQL
programming for PHP and MySQL
how do i get my login page to direct a user to an appropriate page depending on user username, password and domain previlidges from a database. am using php and mysql
View Answer
| Dec 27 2007 7:58 AM GMT
| asked by
Jed04
PHP, MySQL
Database
What is the difference between Hsql and Mysql?
View Answer
| Dec 18 2007 6:54 AM GMT
| asked by
Vidhyadgl
MySQL, HSQL
design a web database application
i want to design a web database application to compile undergraduates results using php and MySql. can i get a worked example?
View Answer
| Nov 5 2007 11:51 AM GMT
| asked by
Apeh
PHP, MySQL
C#.Net
Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend?...
View Answer
| Jul 12 2007 3:58 PM GMT
| asked by
cmcwag
Business/IT alignment, Vendors, Application development
Correlated Subquery - NOT EXIST
Hi -I'm trying to add a not exist subquery in my where statement and have several other joins ahead of it. I'm having difficulty determining where to put the NOT EXIST as the subquery is named as a column - ie blue.color in (select * from .....).Where would I put the NOT EXIST In this case?Thanks.
View Answer
| Feb 21 2007 3:00 PM GMT
| asked by
Holl123
SQL, MySQL, SQL Server
Data Center Builds
Does anyone have any ideas on how to get involved with build outs for data centers from a telecom perspective. My company is looking for opportunities to build out our network but I need to be able to present them with the scenario. I realize this might sound like a "sales" message or...
View Answer
| Jan 9 2007 4:48 PM GMT
| asked by
lejoneric
Budgeting, Business/IT alignment, Compliance
iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB - real-time.We already thanks to me have a number of batch/DTS package type transfers.Do any of you know packages that can make the iSeries files...
View Answer
| Dec 27 2006 10:35 AM GMT
| asked by
JohndeCoville
DB2 universal database, PC/Windows Connectivity, DataManagement
