11,093 Topics
 | |
| | Hello ALL, I have a table contains words extracted from a few documents. [Code] DocID Word Tag 1 Book noun 1 Pen noun 1 Pencil noun 2 There prep 2 Hand noun 2 Have verb 3 Oil noun 3 Thorough adv 3 Drive verb 4 Red adj 4 Blue adj … |
| | I want to import some records in a mySQL database into an Access database.The mySQL database is ina linux server. Can I do this using VB or other languages ? How ? |
 | Hello to all, I have a SQL Manager 2007. I don't know how connect MySQL from VB6. Can you help me PLS.... Can you give me a complete process of connecting a sql database? here is the download link of the sql manager i use. [url]http://www.download.com/EMS-SQL-Manager-2007-Lite-for-MySQL/3000-10254_4-10439256.html[/url] pls help me. . …  |
 | Is it possible to update the AUTO_INCREMENT value who's attributes are primary key, not null, auto increment and also an INT type The thing is I need to synchronize the 'image_id' to access images sequentially and if one row is deleted the sequence is destroyed Help me! [code] <?php include('db_conexn.php'); … |
| | |
| | Hi i have a website hsoted on a shared server with a service provider and i am getting the below error at times while i am adding text in the database thru the CMS module provided to me by the developer. The developer says its a server issue and and … |
| | hello everyone, i need to make a program that will show/load the images stored in mysql database, i've already created the database and my problem is i can't load it in my vb code.... here's my code below Dim conn As MySqlConnection 'connect to database conn = New MySqlConnection() conn.ConnectionString …  |
| | i cant understand why this error commimng up [CODE]<?php $mysql_host="xxxx.xxxxxx.xxxx"; $mysql_user="anuncios"; $mysql_password="xxxxxxx"; $mysql_db = "suecia"; $conn = mysql_connect("$mysql_host","$mysql_user","$mysql_password") or die("Could not connect : " . mysql_error()); mysql_select_db("$mysql_db",$conn) or die("Select database failed"); $code = mysql_query("Select * from jos_call where code = '".@$_REQUEST['nombre']."'",@$conn); if (mysql_num_rows($conn)==0){ //error here// echo @$_REQUEST['nombre'].' - Codigo correcto'; … |
| | I have written a guestbook in php using a MySQL database to store the entries. I am now writing the backend for it so that the rows in the table can be modified via a form. The way the form works is this: A table is displayed on a page … |
| | HI All, I am currently following a tutorial on mysql and php and I am getting this error on displaying results ready for an update in a form. Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/site/update.php on line 11 [CODE]<? $id=$_GET['id']; $username="web183-sql"; $password="sqlpassword"; $database="web183-sql"; mysql_connect(localhost,$username,$password); … |
| | Hi, I need somebody to have a look at my code below and help to see what I have done wrong. I have 3 tables:[B]Student[/B] [I][COLOR="Red"](studentNum,firstName,lastName)[/COLOR][/I], [B]course[/B] ([COLOR="Red"][I]courseID,courseTotalCapacity[/I][/COLOR]), [B]course_allocation[/B] ([I][COLOR="Red"]studentNum,courseID[/COLOR][/I]). The AIM is to allocate students to 2 classes (courses 101 and 102) as long as there is available space … |
| | hi I am learning mysql and have created a table for auditing purposes with fields below , but my problems is I dont know how to go about inserting data into it whenever an event ocurs on my primary tables.especially getting the oldvalue,newvalue,column and table name fields after updates are … |
| | Hi there, Can someone please help me in optimizing a query. The query that I have is as follows: [CODE]CREATE TAbLE RED_WINE_TXN AS SELECT MEMBER_SEQUENCE, SUM(PURCHASE_VALUE) PURCHASE_VALUE, SUM(QUANTITY) QTY FROM PURCHASE_DETAILS a, RED_WINE_SKUS b WHERE a.PRODUCT_NO=b.PRODUCT_NO AND TRANSACTION_DATE>=20071101 GROUP BY MEMBER_SEQUENCE[/CODE] MEMBER_SEQUENCE: DECIMAL (INDEX) PURCHASE_VALUE: DECIMAL QUANTITY: DECIMAL PRODUCT_NO: DECIMAL … |
| | I design a database on Mysql , one of the tables is call 'account' which contains user related information like username, email address etc. Due to large amount of user data running in millions of record, I have decided to partition the account table. The first partition should contain username … |
| | I've got quite a slow query, that I need to get a random record from, however this is proving painfully slow, can anyobdy suggest ways to speed up the following query. SELECT * FROM people WHERE names like "%bert%" or names like "%john smith%".......... or names like "%eric%" ORDER BY … |
| | Hi can someone shed some light on this problem I'm having please? 2 tables SHOWS_ARCHIVE (TABLE 1) ID SHOW_ID AUTHOR SHOWS (TABLE 2) ID When the member logs in they are a loud to see their shows because of the $author permissions; [code] if ($_SESSION['MEMBER_PERM'] == "2") { $author = … |
 | I have this method : public void ExecuteSQL(String SQL) { Koneksi getCn = new Koneksi(); Connection cnExecute = null; try { cnExecute = getCn.getConnection(); int rowNgefek = 0; Statement stExecute = cnExecute.createStatement(); cnExecute.setAutoCommit(true); stExecute.executeUpdate(SQL, rowNgefek); cnExecute.commit(); closingConnection (cnExecute,stExecute); } catch (SQLException e) { System.out.println(e.toString()); } } If insert/delete/update raise error, …  |
| | Hello All, Can anyone help me how to insert html code in mysql database coloumn and also how to change the var char to 1000, for now it is 100. Please help me out thanks 7 regards Raj |
| | Hi, I am in the process of grabbing information from a mysql database. I need to just grab the date that was imported from the xml sheet. Is there any commands that can just grab information listed below: [code]...<expiration-date>2040-12-1</expiration-date>...[/code] This is located in between all the other information from the … |
| | Hi all, I using PHP & MySql. Here's the situation: 1. I have a website which is a meeting place for employees & employers. Employees can sign up for an account & select the skills they have. These skills list will be shown on their resume. I have an array … |
| | Hello, About a week ago, I created a new DB (e...), put it on the server and edited. [B]ALL FINE THERE [/B] However, certain tables with the [I]same names[/I] on a [I]different DB[/I] (f...), on the [I]same hosting account [/I]were over written with the information from DB e.. [LIST] [*]The … |
| | Hi, I have this problem to solve [quote]Create a set of tables to store data for an address book (contact) application. Bare in mind the following design criteria. * The application will be used by multiple people so the database should also store a list of users. * The people … |
| | Hello all, lets say i have a table like this which has 3 columns and 3 rows; -----------------------------------------------------------+ COLUMN_A.....|.....COLUMN_B.....|...COLUMN_C | .........X............|...........X............. |.........X...........| .........X............|...........-...............|.........X...........| ..........-............|...........-...............|.........X...........| -----------------------------------------------------------+ So, now i have an input like; (user submits a form) ----------------------------------------------------+ ......X............|...........X............|..........-.......| ----------------------------------------------------+ now; the first column of row#1 is X so it is … |
| | Hi I'm having trouble with a subquery and really need some help. I'm trying to count to count the number of beats sold by a particular producer. So the first thing I did was SELECT all the beats sold by that producer so I wrote the code [CODE] select name, …  |
 | Hello, i'm working on netbeans and want to access my database using this code: [CODE=java] import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class connect { /** * @param args */ public static void main(String[] args) { try { Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch (Exception ex) { System.out.println("error \n"); … |
 | Hi! I've got a table of, let's say, widgets. Each has a unique id (primary key) and a few other attributes such as widgetid (unique, number) widget_name (string) widget_price (varchar) widget_color (string) BUT, for each widget, I also want to list other widgets (that are listed in the same table) … |
| | i get an excel report each month, There are two columns (person`s name and Salary) in this month report there was 99 persons. my question is , if in next month excel report there are less persons...say 75, and also 23 persons raised their salary.. how can i updatae this … |
| | Any one help me. How do i insert Image in to MYSQL5.0 By use of vb.net2005 ? |
| | Hello everyone, I am setting up a section of coding in which I need to add and subtract certain values to a mysql field. However ...the code only seems to add negative numbers (-13.0) as a postive number to the database and its really confusing me now! :( What I … |
| | Hi, This is urgent if any one could please help me resolve the stated issue....... I know how to create cursors in ProC* and how to manipulate them. But I have to do it with a combination of C and MySql. Can any one guide me as to how the …  |
| | Hello all, For creating dynamic title tags, I tried using [code=php] <title>welcome<?php echo '$pagetitle';?></title> </head> <body> : : <?php : $pagetitle = '$row[2]'; ?> //closing rest of the tags. [/code] I get nothing displayed on title ! So i changed the code to, [code=php] <html> <head> </head> <body> : : … |
| | I need to get the 'customers_info_date_account_created' from the 'customers_info' table where the field 'customers_info_id' matches with the field 'customers_id' in the following query: [code=sql]SELECT * FROM customers WHERE customers_id NOT IN( SELECT customers_id FROM orders )[/code] I basically have all the information in columns from the query and need an … |
| | I have a PHP script I am trying to convert to PERL and need some help. Here is the code in PHP [code] $store_list_name = $prod[10]; $category = $prod[11]; $sub_category = $prod[12]; $searchfor = $store_list_name . "->" . $category . "->" . $sub_category; $getcat = mysql_query("SELECT * FROM categories WHERE … |
| | hi all how to run the multiple sql statements same time in mysql querybrowser? for example i am write two sql statements, i want run the second statements in mysql query browser, how to terminate the first statement thanks |
| | Hello everyone. I've just signed up to 1 years hosting with Uk based Fasthosts. They provide support for Python scripting and a free 150MB MySQL database on their Linux package. My problem is that they don't seem to have the MySQLdb module installed. Is there any way I can get … |
| | What i want to do is display all the customers data which is in the 'customers' table where their 'customers_id' is NOT IN the 'customers_id' field in the 'orders' table. I hope i made sense! Thanks, Billy |
| | Hello.. I couldnt find anything for this topic. I know how to connect to a mysql database and close the connection.But that means that for every script a connection should be established and closed. Is this right and ok for big projects? About 200 concurrent users for example; Having a … |
| | I'm quite knowledgeable with T-SQL and know a little VFP. I would like to code what I think would be a very simple program. I have an excel spreadsheet that has two columns, a date column and a system code column. One of the applications that I use on a … |
| | Hi all, I am using MS Windows SP2. I should like to share my positive and negative experience with the PPM (Perl Package Manager) with the community. For a reason I uninstalled Perl from my computer and installed again. After installation only DBI was present, and for Mysql the DBD::mysql … |
| | Hi, I was wondering how I would enter something like a paragraph in MySQL if you declared it as type TEXT. So how would I enter something like: [COLOR="Red"] John 3:16 (New International Version) 16" For God so loved the world that he gave his one and only Son,[a] that … |
| | Hi, For 2 lakh records, this works well but when the total number of queries is more than 5 lakh it does not . Actually i have 64 lakh records to work with and this gets forever. [code=sql]UPDATE tmp_yk_contributor set score_last_update = '$date' , ykscore = (IFNULL((select avg(score)*0.8 from yk_entity_score … |
| | hi experts, Is it possible that i could get the 3 queries made into one single query.Any help could make me understand and correct myelf in better queries. Each query is taking long time and sometimes the first query crashes , with > show processlist showing status as 'copying to … |
| | hi all, i have a auto suggestion box which displays countries when we type [B]a[/B] it will display all countries starting with letter [B]a[/B] like alaska,australia etc...,but i want to display every name which has letter [B]a[/B] in names like [B]a[/B]ustr[B]a[/B]li[B]a[/B],indi[B]a[/B], etc... |
| | OK .. I was migrating an application from a staging server where the MySQL version is 4.1.10a to a live server where the MySQL version is 5.0.45. There apparently is quite a difference between query syntax on one versus the other. For example, in version 4, this worked: [CODE]SELECT uas.usr_id_users, … |
| | I am attempting to input data from a log file into a database with tables for each network device. The table name is set via a parameter for the function. The script crashes after running stating the table name does not exist. If the actual table name (routerA) is listed … |
| | hi friends, i want to get backup from MySQL DB by use php code. |
| | I have 2 tables with the basic structure town, latitude, longitude postcode, latitude, longitude where latitude and longitude are both floats, and the town and postcode are just descriptive text. I want a query that will display the closest postcode to each town, is it possible? |
| | I was wondering how do you countdown to a given date, like for and enevnt or something. Let's say you know the target date is let's say Christmas and you have the current date, how do I calculate how many days are between them? |
| | Hi , Wishes! I am doing a iterative calculation and in the last iteration, i update few of my tables. What i am trying to do is , make this update more perfect. Is it possible for me to do updates in small steps with using LIMIT. i do not … |
| | OK, now that I managed to insert data properly into a relational database using a linking table, I am now faced with pulling the data properly out of the database, a displaying it so it makes sense. As a recap, I have inserted user data into a data base that … |
The End.