7,494 Archived Topics
Remove Filter  | |
 | ** CAN A MYSQLD EXPERT PLEASE HELP ME OUT ON THIS ONE ** I am having a problem with my MySQLd on db2.daniweb.com going through periods of 1-2 minutes every couple of hours where it refuses connections from Apache on web.daniweb.com. The error being thrown back is: mysql_pconnect(): Can't connect … Databases apache client-server email mysql open-source redhat unix web-server  |
| | Hi there, I keep getting the following error message when i run this script: [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/home/httpd/vhosts/tellproperties.com/httpdocs/testing/register.php[/B] on line [B]42[/B] [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/home/httpd/vhosts/tellproperties.com/httpdocs/testing/register.php[/B] on line [B]43[/B] No Database Selected [CODE] … Databases email first-post mysql sql |
| | Hello Message popup everytime log-on to the computer like this: "Error loading p2esocks_1012.dll The specified module could not be found" Would anybody help me to get rid of this please.... Mandoos Databases microsoft-access |
| | I ran the SP3a installation and it didn't return any errors along the way. However, when I ran the query to look at the current version of SQL it still has the service pack at version 1. Any idea why? P.S. I think the installation process is asinine. |
| | |
 | Hi there, I was trying to get a [B]Scheduled Job[/B] (in SQL Server 2000) to [B]run every second[/B] or two. I had three T-Sql blocks I needed to execute every two seconds, and you know you can just schedule recurring times to every minute. I started out by introducing multiple … |
| | Hi I have 3 tables that I need to display in a report TableA idxA valueA 1, a 2, b 3, c TableB idxB bidxA valueB 1, 1, aa 2, 1, bb 3, 1, cc 4, 2, aa 5, 2, cc TableC idxC bidcA valueC 1, 1, dd 2, 1, … |
| | Hi, I have a composite in a Microsoft Access Database that is not populating, when I add data to the two tables connected to it you would expect the Composite Key to populate as well wouldn't you? But this is not happening, can anyone expalain why and how this problem … Databases microsoft-access sql |
| | How can I create a Formula to figure out a Golf Handicap IN MS SQL Step 1 (Score - Course Rating) x 113 / Slope Rating For example, let's say the score is 85, the course rating 72.2, the slope 131 The formula would be (85 - 72.2) x 113 … |
| | [U]Access 97[/U] I am developing a system and am getting the following error on compilation - "Cyclic reference of projects not allowed". The help system advises me to resolve the reference but doesn't say how. The compilation window does not highlight the error in the code and I can't figure … Databases microsoft-access |
 | [B]Hi all The problem is the following : [list]I am in a project that contains a table of users[COLOR=Green](user_tbl)[/COLOR] and another table of groups[COLOR=Green](Group_tbl)[/COLOR] . and each group can contains multi-user by [U]Group_Id[/U] which is foreign key in [COLOR=Green]user_tbl[/COLOR] . [/list] [list]I am now about creating a trigger that happens … Databases mssql |
| | The table I'm searching is varchar. The entries I'm interested in are only numeric. But for some reason there's mixed string/int entries. How can I chose only the numeric values? Databases mssql |
| | I've recently become the defacto DBA of two MSSQL databases at work because I am the only one with SQL experience. I have been asked to do some tasks with the databases but this requires and understanding of their structure. I cannot find anything akin to MySQL's mysqldump for mssql … |
| | Hi Guys! I am newbie to MS-SQL Server and I’ve run into a very very serious trouble. My company/organization that I am currently with is running MS-SQL Server 2000 Standard and our problem is: MEMORY Out of my stupidity I upgraded our server’s memory to 4 GIG and to our … Databases mssql open-source sql windows-server |
| | IWhat exactly is the "unsigned" use for in sql and when should i consider using it? |
| | Hi I'm new here so be gentle! ;) I have a php form which poppulates an HTML <Select> tag with a list of approx 2500 items which consist of an id; a code and a name. The items come from a MySql database To make it easier to use I … Databases mysql |
| | I've constructed a photo gallery with a dynamic CMS backend that allows the content providers to upload, delete, etc images. All images are stored as reformated jpeg files (processed by the GDLib on upload) and the relevant metadata is stored in a table called `gallery`. References are made by an … Databases cms image javascript mysql php |
| | I don't know if this is possible but would appreciate any help. RefDes table: ------------------------------------------ ID RefDes ------------------------------------------ 123 VR1 123 C1 124 C2 123 C2 123 R1 125 R2 ------------------------------------------ Is it possible to write a SELECT statement that will produce the following? ------------------------------------------- ID AllRefDes ------------------------------------------- 123 VR1, … Databases mssql |
| | Hello, i've got two tabels, "Artists" and "Music". The relevant columns are: Artists: [Id],[Name] Music: [Id],[ArtistId], [Title],[Added] I want select the post's in the music table, but instead of returning the artist id, it should return [Name] from the Artist table where Music.ArtistId = Artists.Id (so it looks in the … Databases first-post mssql |
| | [b]PREFACE:[/b] My name is Al and I'm a loving moron who locked himself out of MySql. Alright, Let's rock. I don't exactly remember changing my password, but since I was in the Terminal using commands like [b]-u password[/b], I think I might have done it on accident. So... I need …  |
| | Is it easy or even possible for a user to create a cookie on his own and use it on a site that uses authentication with cookies? Databases  |
| | Hello, I'm pretty much a newbie with SQL. I have a database that is growing out of control and I'm unable to delete any records (data) from it. I've tried numerous open source applications but nothing has worked. The database is with a hosting and they provide ASP.NET Enterprise Manager. … Databases asp asp.net mssql open-source sql |
| | |
| | Hi, I am having a table with 16 lakhs records in it. Each record contains approximately 50 columns. I am using MSSQL Database. Basically the table contains details of the user's registration details. I have a application built in VB.net which will be selecting a random user_id and then searches … |
| | Is there another way to make a column in a table the primary key if you already assigned it to the autonumber column? I would like to make either the student id or the social security number the primary key. Databases microsoft microsoft-access |
| | Hi, I am with a web host using mysql 4.0 and phpmyadmin 2.5.5 p\1 I am trying to get my html user form on my website to insert into mysql database. I keep getting: Error! Could not select the database: Access denied for user: 'match.match.com@10.80.0.%' to database 'mydb' Can you … Databases mysql php web-server |
| | [code] CREATE TABLE my_feature ( pk_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, member_id INT(8) UNSIGNED NOT NULL, time_added DATETIME NOT NULL, personal_questions BOOL NULL, hits INTEGER UNSIGNED NULL, PRIMARY KEY (pk_id)); [/code] When I put this into the MySQL Query Browser I get this error: You have an error in your … |
| | Hi, While I'm not entirely new with SQL, I am not by any means highly knowledgable. I'm attempting to write a SQL statement to do the following, and having no luck: Assumptions: There is only one table, with several fields of metadata including the following. 1 field (integer) that indicates … |
| | I am using MySQL 4 and trying to cache my queries per this tutorial: [url="http://dev.mysql.com/doc/refman/4.1/en/query-cache-configuration.html"]http://dev.mysql.com/doc/refman/4.1/en/query-cache-configuration.html[/url] Right now, my query_cache_size is set to 0. I would like to set both the query_cache_size and query_cache_limit parameters. However, I'm receiving the following error message: [code]mysql > ERROR 1227: Access denied. You need the … Databases mysql |
| | I'm looking for a way to compare 2 lists of keywords and return the number of matches. I'm currently working with PHP and MySQL, but I'm not sure how to go about this task. Any suggestions are appreciated. Thanks, J_ Databases mysql |
| | Hello, I have this query: SELECT players.id AS id, players.name AS name, players.surname AS surname, players.email AS email, calendar.start AS beginning, calendar.end AS finnish, calendar.name AS title, calendar.event AS description, calendar.id AS eventid FROM `calendar` , `attendance` , `players` WHERE (attendance.present = "yes" AND calendar.start BETWEEN "1141060879" AND "1141665679" AND … |
| | Hi all, I'm looking for a nice query tool to query MS SQL and/or Sybase databases. Currently, I'm using Excel to do some minor query stuffs...and I don't mind using it but it get's repetitive when you have to do it for 70 different databases. So I'm looking for something … Databases mssql open-source sql |
| | I'm running a query through XML from the local database which uses PHPMyAdmin to a remote one which uses MSSQL. Unfortunately I have no way of checking syntax against MSSQL so all I know is that this works in PHPMyAdmin. So the query gets as far as running, but is … |
| | i try to make a select table with condition now such as; <? ... $res = $conn->Execute("SELECT ID_SKENARIO,DATE_I FROM T_SCENARIO WHERE DATE_I = NOW"); While(!$res ->EOF) { echo $res->fields[0]; } ... ?> what is the right synta for condition date is now ? please help me... :sad: Databases oracle |
| | [COLOR=SeaGreen]Hi guys, i hope u can help me solve this prob of mine. Im currently werking on this project and somehow im unable to insert this data into my database eventhough the data was being retrieved. Can anione help :sad: [/COLOR] <% option explicit %> <% response.buffer = true %> … |
| | i am interested in knowing how to make my resultset updatable. i am currently running jdk5.0 so it should already acquire such information, but the following code is throwing me errors. public String execute( String newPassword ) throws ClassNotFoundException { //private variables Connection conn = null; Statement stmt = null; … |
| | Hello have a good day is there a way to retrive top records by range , i mean like this "select top 15 to 20 record from Table name any condition" i dont mean top 15 or top 20, i mean records from 15-20 take care thanking u in advance … Databases mssql  |
| | Hello have a good day is there any way to retrieve record number with each record in simple sql qry? e.g select "REC_no",name from "table_name" the result should display like this 1 ,noman 2,imran 3,Jose etc take care thanking u in advance Bye |
| | [CENTER][COLOR=Navy]Hi i am creating a database im ok, just havent used it for years and years. I need a defult value which will add todays date. And a validation Rule that will prevent date entries prior to 1/1/2002[/COLOR] [COLOR=Navy]Can anyone please help me!! Thanks Jay[/COLOR][/CENTER] [CENTER][COLOR=Navy]AND MY INPUT MASK IS … Databases microsoft microsoft-access |
| | HI! I am Charis 19 yrs old. I am a graduating college student. I am having my thesis right now. I would like to know that it is posible to connect a Paradox file to the web. Our thesis has a part that all the data from Paradox should be … Databases  |
| | Ok, I am looking to start a database, fillable by members that I add, with some of the following information. Personal Info: Name NickName Email About Me Vehicle Info: Car Make Car Model Year Engine Modifications - (this area will be need to be multiple lines, say upwards of 20?) … Databases email pay-per-click |
| | |
| | right when i type the date in a need a validation for it dusnt allow u to book any less than 7 days in advance from NOW (DATE cz i dont want time included). If longer then 2 months in advance also dusnt let u for as computing course work … Databases microsoft microsoft-access |
| | Hi, I am new to db admin and would appreciate some help with a design issue. We currently have 3 applications all with their own DB which all contain a product table. It is different in all 3 DB's and I need to replace all 3 with one enterprise wise … Databases |
| | Hi, I've had a website built for me using asp and mssql. Im getting errors relating to the date format in queries being submitted. The asp is trying to insert dates in format dd/mm/yyyy, but after testing my mssql server is expecting the dates in format yyyy/mm/dd. Is there a … |
| | hey guys, i need to setup a database server, and as of now , i do not have any knowledge about MySQL, PHP, and things realted ...although i have a fair knowledge of how things work, i have used Access for my earlier databases, i want to have adress book(forms) … Databases mysql  |
| | Hiya all ive decided to do my final year project designing an online music video library that will allow multiple access by many users to the same files that will be highly available, with facilities to access the video library by pc, pda and mobile phones. how would i integrate … |
| | I would like to know how I can backup Mysql tables from hosting server to my local pc? I don't want to use phpMyAdmin, is there some simple commands to do that(I use PHP)? and how to restore it back to hosting server? I assume it will use csv file. … Databases mysql |
| | whats wrong with this code? i'm really confused! when i use INSERT code insted of UPDATE in my file, every thing is ok. but when i use UPDATE,it doesn't work!! UPDATE: [CODE]$query = "UPDATE $tblname SET title='$title', desc='$desc', body='$body', time='$time', faday='$faday', famonth='$famonth', fayear='$fayear', fu_show='$fu_show', fu_day='$fu_day', fu_month='$fu_month', fu_year='$fu_year', wshow='$wshow', dshow='$dshow' WHERE … Databases mysql |
| | Hey all What is with this query $query = mysql_query("UPDATE `namitposts` SET `title` = '$topic' , `date` = '$date' ', `postee` = '$postee', `post` = '$post_text' , `ip` = '$ip' WHERE `id` = '$del'") . mysql_error(); Its not passing the variables am getting this error message Notice: Query error You … Databases first-post mysql sql |
The End.