7,494 Archived Topics
Remove Filter  | |
| | I have a field Status in my table message Its value when any message is entered in table is 1 but I want to alter it to 0 after 1 day of message posting how can I do so Plz help me Databases mysql |
| | Hello, I have downloaded "Microsoft SQL Server JDBC Driver 3.0" and tried sample code. I added "sqljdbc.jar" and "sqljdbc4.jar" in Libraries. But getting error, [COLOR="Red"]java.sql.SQLException: No suitable driver found for jdbc:sqlserver:bug_tracking at java.sql.DriverManager.getConnection(DriverManager.java:602) at java.sql.DriverManager.getConnection(DriverManager.java:185) at Main.main(Main.java:18)[/COLOR] The code is given below : [CODE]import java.sql.*; public class Main { public … |
| | Hello , I am working on getting this Mortgage repayment calculation code to work for my Access07DB, the code for was copied from some 2006 post on a vb forum. But some things I cant get to work [COLOR="red"]I will put the bad lines in red[/COLOR] [CODE] Option Compare Database … Databases microsoft-access |
| | hi, I have date in this format December 2 2009 December 2 2009 December 2 2009 and i want to insert it in my table in mysql .I m inserting this with the help of perl means i m doing my program in perl .ook at my program [code=perl]#!/usr/bin/perl use … |
| | Hello, I have two tables--QUESTIONS, ANSWERS. I store the questions in one table and the answers in the second. Table Structure--QUESTIONS Field 1: Question_ID Field 2: Question Field 3: Question_Type (There are 3 types of questions) Field 4: Step_ID (There are 15 steps in the program) Table Structure--ANSWERS Field 1: … Databases data-structure mysql |
| | I have a table like this (say, friends): [CODE] |_name1_|_name2_| | james | sarah | | bob | james | | james | dave | [/CODE] I want all james' friends. It will need to include 'bob' as well but I can not figure out what the query will need … Databases mysql |
 | Hello There, I am Using This code to backup mysql database from my hosting server. [CODE]#!/bin/bash # # MySQL Backup Script # VER. 2.5 - http://sourceforge.net/projects/automysqlbackup/ # Copyright (c) 2002-2003 wipe_out@lycos.co.uk # # This program is free software; you can redistribute it and/or modify # it under the terms of … |
| | Hi everyone and thank you for helping me... again :icon_neutral: I am trying to perform a MATCH AGAINST sql query on one of my table called "what". [ICODE]id (int 11) PRIMARY org-id (int 11) keyword (varchar 100) FULLTEXT bid (DECIMAL 4,2)[/ICODE] I want to perform a search on the column … |
| | Hi, i am relatively new to mysql just learning the basics really. i have googled this but there is so many discussions on it. Could someone just give a simplified answer to what is the difference between using Union or Join and when would you use one or the other? … Databases mysql |
| | working on a system with 2 tables both have the exact same fields - the tables are past_participant and course_participant - CP table has all current students whilst the PP has only past students. after a course concluded, that set of students is transferred from CP to the PP table. … |
| | hi, I have these two tables: [CODE]personal_details (staff_ID integer PRIMARY KEY, title varchar(10), fn varchar(250), ln varchar(250), mn varchar(250), dob varchar(50), hometown varchar(250), securityno varchar(50), phone varchar(15), phone2 varchar(15), phone3 varchar(15), email varchar(50), address varchar(300), confirmation varchar(50), retirement varchar(50));[/CODE] and [CODE]training( training_ID integer primary key NOT NULL, staff_ID varchar(100), training_level … Databases sqlite |
| | Hi I have to work with oracle application express 3.2 I have some doubt on installation: 1.whether i need to load oracle 9i release 1 or release 2 2.whether it is possible to work with windows vista/xp? 3. what are the requirements to install apex 3.2?? i am new to … Databases oracle windows-vista |
| | so there are 2 tables course participant and past participant - both have same fields. i want to write a query that selects both from course participant and past participant if search option "find all" is called. i out everypossible combination but it just doesnt get right - pls help |
| | from mysql command line, what's the command to import query from a text file? does mysql has this ability? it would be handy if so.... does the text file have to have mysql file type? please be a bit specific. thanks very much. Databases mysql |
| | Hi, I tried to use dynamic table names like: [CODE]create table outgoing_%Y%m%d ( ip_src CHAR(15) NOT NULL, ip_dst CHAR(15) NOT NULL, src_port INT(2) UNSIGNED NOT NULL, dst_port INT(2) UNSIGNED NOT NULL, stamp DATETIME, PRIMARY KEY (ip_src, ip_dst, src_port, dst_port, stamp_inserted) ); [/CODE] but every time i got message about syntax … Databases mysql |
| | hi i need to create a query that will query my 6 tables that have an amount column & date paid column. i need to total up all the amounts due, so therefore the datepaid column would be null. can anyone help how i would be able to view how … Databases mysql |
| | Please can you help. I have been trying create a form to insert some data into a database. (I am coding with PHP and MYSQL). When I put any data into the field called enter treatments completed the database gets updated with the treatments_completed column containing a 0 and then … |
| | [B]SHA1 my password fields all at once by running a query, I need to know how to write the query[/B] What I want to do is update all password fields in my database to be SHA1 Can anyone help me to run a query to update all fields as I … |
| | Hello Everybody, I have used inner join with two tables to join them and tried to calculate the sum of rows. Now the table descriptions are- Table1- agent_business_collection (it stores business collection of an agent of different business packages) Table2 - agent_business_commission (it stores commission of an agent against different … Databases mssql |
 | Hey guys, this is probably a really simple question for you experts so I hope you can help..! Basically I have three separate html fields for the user's date of birth: "year" "month" and "date" All I'm trying to do is to take these three from the form and insert … Databases mysql |
| | Morning I have a question here How do I go about it in Access say if I want to split a line (row) into different lines like these fields? Drug name1 Drug name2 Drug name3 Drug name4 Drug name5 Drug name6 So what I want is to split the Drug … Databases microsoft-access |
| | Hi thanks for reply, I just tried that and it does the same - both phrases on the same line in the RTF memo field Ive used vbnewline in a msgbox before and works fine, but it stumped me as to why its not working in memo field. once i … Databases microsoft-access |
| | hi, i had a post in php re display a countdown for policy, it got side tracked to inserting the date properly into mysql database. that is now resolved. what i have is a database setup like this, and if anyone could tell me if this is wrong design before … Databases database-design mysql |
| | Hi there (Can DoCmd.openform allow formname from stored string value?) I am needing to vary the FormName part of the .openform based on a result looked up in another table. as I have 10 Different forms that will be specific to a certain kind of record. My code something like … Databases microsoft-access |
| | Hello all i am new to sql, iam having a requirement where i need to have a distinct value from the result lets say example, contacts table id name --- -------- 1 john 2 jason 3 mark address table id address conid -- ------ ----- 1 newlane1 1 2 newlane2 … Databases mysql |
| | Hello guys help pls i'm trying to populate data from MS Database to list-view [code] string Collect_FULL = "SELECT FirstName, MiddleName, LastName, " + " Gender, DoB, Dependents, Address + ', ' + City + ', ' + State + ', ' + ZipCode AS Address, PhoneNumber, MobileNumber " Status … |
| | I was searching around but I could not find it: I'd like a tool(free or paid) that is able to manage multiple MySql servers from the same GUI. I know about a few thick-client apps that do this, but I need one that you can use it from internet(forget about … |
| | Hello, i am just a beginner,i have no idea on what system should i have to start. Right now, i only think as Hotel Management System, will anybody help on how to start it?Thank you ahead. Databases  |
| | Hi I have a query which i run to give me the monthly amount of money that needs to get loaded to our consultants cards. Our system has changed and I need to get the same data but differently The query needs to join three tables consultants,voucher,gift_cards. The only difficulty … Databases mysql |
| | I was searching around but I could not find it: I'd like a tool(free or paid) that is able to manage multiple MySql servers from the same GUI. I know about few thick-client apps that do this, but I need one that you can use it from internet. So far … |
| | Hello' I'm using following code and getting mysqlerror Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs/..... Code is $query="SELECT ('$retfield') FROM ('$table') WHERE ('$givefield')=('$val')"; $res=mysql_query($query); if(mysql_num_rows($res) > 0){ } Upto my knowledge I'm using correct syntax bt I dnt where I'm going wrong. Can anyone help … Databases mysql |
| | Hi All, I am trying to convert the following access update query into TSQL without any luck: UPDATE tblCattle INNER JOIN tblFarmDetails ON tblCattle.strEartag = tblFarmDetails.EarTagNo SET curMartPrice = tblFarmDetails.MartPric WHERE (curMartPrice=0 Or curMartPrice Is Null); First I tried simply pasting in the query with no luck so below is … Databases microsoft-access mssql |
| | Hi to all, Example: CREATE TABLE test(name varchar(20) NOT NULL DEFAULT ''); In the above query varchar is described as NOT NULL.Then why we are inserting DEFAULT value as '' (null). Thanks in advance, Prem Databases mysql  |
| | Please is it possible to have two where statement in an sql query? for example: SELECT * FROM Persons WHERE FirstName='Peter' but I want another condition which will also pass the query like: SELECT * FROM Persons WHERE house='duplex' or car='Honda' Is the second query correct if not how do … Databases oracle  |
| | I have a problem I have a long table with many costumers, each costumer have between 70-100 bills how can i get for each one his top 5, all the replies giving me only the top 5 of the first.(MsSQL!) 10X Ofir Databases mssql |
| | Hi, When I register a member using my script, why one of the column have "Resource id #14"?? Below is the code: if($do->new_user($username, $encoded_password, $email, $alertpay, $referral, $country, $c, $referral2)) {mysql_query("INSERT INTO history (username,type,time,custom1,custom2,custom3,custom4,custom5) VALUES ('{$username}','joined',unix_timestamp(),'0','0','0','0','0')"); mysql_query("UPDATE users SET balance=balance+'0.20' WHERE username='{$referral}'")or die(mysql_error()); mysql_query("UPDATE stats SET users = users + … Databases mysql |
| | Please is it possible to have two where statement in an sql query? for example: SELECT * FROM Persons WHERE FirstName='Peter' but I want another condition which will also pass the query like: SELECT * FROM Persons WHERE house='duplex' or car='Honda' Is the second query correct if not how do … Databases mysql |
| | In my VB6 project i have a text area field, iwant to insert data which i give in that text area wants to insert into Access database. For that which data type i need to take for that column. 1) If i take Memo or text as datatype: only singleline … Databases microsoft-access  |
| | Hello everyone, I currently doing a database project, which is part of my coursework, and I am having some difficulties. So, I am making it in Microsoft Access 2003. In my form, I want have to tabs (Client and Music Store), and I already have 2 tables, for each tab. … Databases microsoft-access |
| | how to obtain query execution time? i need for mysql query in java... does anyone know Databases mysql |
| | Hello all. I have a moderate knowledge on how to create databases in Access but I am having a problem. I want to be able to improve the exams we write by tracking the questions which were answered wrongly to be able to improve the exam. Here is what I … Databases |
| | Running a SQL query from the following code: [CODE] <php if(sizeof($_POST['addcandidate'])){ foreach($_POST['addcandidate'] as $id){ $name= mysql_query("SELECT LastName FROM candidate WHERE Candidate_ID= '$id'"); while($rowz= mysql_fetch_assoc($name)){ $candidatename= $rowz['LastName']; $alter= "ALTER TABLE '$votertable' ADD '$candidatename' int"; mysql_query($alter) or die(mysql_error()); } } } ?> [/CODE] I return Im getting: [COLOR="Red"]#1064 - You have an … |
| | Im in over my head and have a small project to complete using MS Access. It involves setting up 3 tables, creating forms, queries and a report. I have a narrative that describes what is needed. I am willing to pay to get this done, but for somebody that is … Databases career microsoft-access |
| | Hello! i have a mysql problem - i need to execute a query which selects field from one table and joins another table which is determined by a field value in table 1. for example, table1 contains fields ID(primary int) and someotherfield(varchar). i need to join table2 or table3 depending … Databases mysql |
| | in mysql i have a field named S_No which i placed on auto_increment. whenever i delete the second row from the database and next time when i m trying to add another row in database its starts from the 3rd incremental value and basically i don't want it, i wana … Databases mysql |
| | Hey there, I'm having problems importing my sql file via phpmyadmin. It keeps throwing up the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'id`) ); CREATE TABLE `sessions`( … |
| | Hi iam having a problem with combining a few union statement together. The statements run separately without any problem. The below union outputs the following results: team points leeds 3 [code] select team ,points from ( select hometeam team, sum(homepoints) points from fixtures where competitionname = 'prem' group by hometeam … Databases mysql  |
| | Hello! I'm trying to migrate a database table from a joomla installation to drupal. The problem is with the column containing image file names. The column in the joomla table only contains the filename and drupal needs the sourcepath to the image as well. So I'm wondering if there's a … Databases mysql |
| | I am trying to insert data from a form into a SQL Server 2005 database. The only code examples I can find are for Access databases. I am having a problem at the execute command. I have tried three different ways to execute but the page goes to an error … Databases asp open-source sql  |
| |
The End.