10,946 Topics
 | |
| | Hi Any suggestion on how to save an image file into mysql using the .NET api? I tried code similar to this : MemoryStream stream = new MemoryStream(); byte[] imgData; //previously available image in the program Image.Save(stream,ImageFormat.Jpeg);// saves the image into the stream imgData = stream.ToArray(); //now I have the … |
| | I Currently have a form where we have people putting an application forward and the form consists of this code: [CODE]<label for="age">Age Group:<span class="red">*</span></label><br/>//here!!!! <input name="age" type="checkbox" value="11s">11/under <input name="age" type="checkbox" value="13s">13/under <input name="age" type="checkbox" value="17s">17/under <input name="age" type="checkbox" value="open">Open <em>If trailing for two age groups please ensure both age … |
| | Hey, I am wondering if it is possible to transfer data from one database to another e.g. from a SQLlite database to a mySql database. I know they are different type and styles of database. The SQLlite database would be stored on android phone and mySQL seperatly on a appropriated … |
 | Hi, I have DAL class and I have done Query Parametrization to avoid SQL injection. As you can see the weakpoing for Dynamic Query is table_name and column name. I have made small function to (hopefully) validate table variable before I can add to SQL command string. Now I was … |
| | [CODE]<html> <head> <title>Applicant Login Page </title> </head> <center> <body bgcolor = "#000000" text = "#70db93"> <h1> Passport System <hr> </h1> </center> <form> <p> Fill in the form below. </p> Title <input type = "radio" name = "response" value = "Mr" checked = "checked"> Mr <input type = "radio" name = … |
| | Any help appreciated in advance.... I have been trying to get a javascript to use ajax to call a php script to read from an mysql database and write out an xml dom document so that I can add markers to a google map. I think I have all the … |
| | Here is my code,problem is i'm able to login even with wrong username and password. Can anybody tell wat is the mistake in my code.. [CODE] using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using MySql.Data.MySqlClient; …  |
| | I've been following several tutorials in order to build a simple search engine for my website. But I can't seem to be able to do pagination I.E show results by pages (10 per page). I'll list the code I have thus far and hopefully if there's someone well versed with …  |
 | The application is supposed to install the following without connecting to internet. .Net Framework 3.5 MySQL Server (noinstall zip) - custom install dir, basedir, datadir - run as service with custom name My SQL Connector Restore Mysql db Update Config file with the MySQL uname/pwd. I have all the msi … |
| | hey, i ma creating a join of the same table the output i want is something like this: |Ticket Ref Number|Ticked Opened On|Ticket Closed On|Time Spent In Minutes|TotalAverage| |0000712 |2011-09-14 |2011-10-18 |20023 | 12hours| |0000200 |2011-06-14 |2011-10-08 |40023 | (null)| |0000001 |2010-06-14 |2011-10-02 |20023 | (null)| |0000099 |2010-07-13 |2011-10-01 |10022 … |
| | Hello guys, i have a problem with my fetching records, i need to put each photo inside a cell , now that has been done okay the problem is i need to put 5 photos each row , now i have 6 in a row , i tried to use …  |
| | Hi, I want the week of the year, given a date. I used YEARWEEK('1987-01-01') which return me 198653, but i want it 198701 as the output which means the year and the week number of that year. How to do this... Thanks in advance!! |
| | [B]Hi, I am new to mySQL database design. I am having trouble getting my head around the best way to design my database for a simple online game. Here are the details followed by my attempt and questions:[/B] [COLOR="Red"]A game where multiple decisions are made by teams competing against each … |
| | Hello I want to send xml values to a database I just created, here is the xml file <record> <name>tcpmux</name> <protocol>tcp</protocol> <xref type="person" data="Mark_Lottor"/> <description>TCP Port Service Multiplexer</description> <number>1</number> </record> <record> <name>tcpmux</name> <protocol>udp</protocol> <xref type="person" data="Mark_Lottor"/> <description>TCP Port Service Multiplexer</description> <number>1</number> </record> I've got 4 columns in my database:- ServiceName, … |
| | Dear All, I have a query as below.It works fine . The problem is I have time range for me to select the data normaly on daily basis. My problem here is the dateTimeStartJourney and dateTimeEndJourney is stored as GMT 0. So when I search I would like to define … |
| | hi i am working on db design of multilingual site. For creating multilingual site we usually use xml or different col in table represting language. I am thinking of using diferernt db for each languge,it will simplifies many things. so my question is that, is this thing of using muliple … |
| | Hello. I am trying to fix this for about 10 hours and i can't do it. I got a template from web and trying to make it dynamic. Somehow, i did something till now.. It get images from a database. Each picture is kind of a gallery and is somewhat … |
| | Hello guys, I've been to a lot of forums and discussions about this but I never found precise solution. I'm having a WEB application in ASP.NET written in C# and a MySQL database behind. I made a button "Import from Excel" which has SQL command: "LOAD DATA INFILE 'importTest2MorePads.csv' INTO … |
| | I current have a column in my database called ConveyorNumber, which could be something like CMD1234, CMD1256, CMD1136 etc. I also have a column called Asset_type which relates to the conveyor number. So depending on the conveyor number the asset type will change, its a description of the conveyor type. … |
 | Hello I need to create a pdf doc which will look like the word doc attached, and have to use php to do so. In the doc, the blue texts will need to be filled from data fetched from table User in mysql, and the Autofill part as well will … |
| | Hi everyone :) I am working on a small error message, but i can not seem to get it to work correctly. Basically, what I am trying to do, is check the account balance field from a mysql database against a variable of $smsnum smsnum is automatically populated based on … |
| | Hello guys, I found a lot examples about this one but I still don't have it all working. So the thing is that I have a button in my C# web application called Export to Excel. The functionality should works as if the button is clicked - it just simply … |
| | |
| | Hi, I am posting in PHP forum as I believe it is a PHP problem. I have seen examples of inserting multiple rows and it seems there are generally 2 options...to use multiple insert commands or to 'concatonate' the query. I have tried these options but with no success. So … |
| | Can anyone tell me if the following query can be done? [CODE]mysql_query("SELECT a, b, (a+b) AS c FROM table WHERE c=1");[/CODE] When I try this I get an unknown column error for c. In order to get the query to work I have had to do this [CODE]mysql_query("SELECT a, b, …  |
| | I have changed a column in my database from the primary Key to Index, as i need to allow the same reference in the column for multiple entries with different dates against them, but now i need to adjust my queries. how do i do this? |
| | Firstly, Sorry for the long post :) Im currently creating a training database for use within the business (not done many getting used to coding) I used MySQLMaestro to construct the datagrid and have modified it to suit most my needs. however i have one issue that i cant resolve. … |
| | Hello there Daniweb community, today i encountered a problem while developing a Desktop Application in C# With Mysql (MySql.Data.MySqlClient). Im not using ODBC. The situation is the following: When NOT executing two queries, the data gets processed and everything works fine. However, once there are two queries, problems appear. Its … |
 | I want the post_delete column to generate unique id's so that when I want to delete a comment for e.g. I can refer to the post_delete's value. [B]Here is my users TABLE[/B] [CODE]CREATE TABLE users ( user_id INT(8) NOT NULL AUTO_INCREMENT, user_name VARCHAR(30) NOT NULL, user_pass VARCHAR(255) NOT NULL, user_email … |
| | Hey guys.. this isn't a coding qs... my php cant read any of my mysql functions... eg. mysql_connect, etc.. everything else in my php works... but even if i echo after mysql_connect it wn't print, but if i echo before it will... its not a coding problem because it works … |
| | Hi, I am having an issue with updating my database with info from an excel spreadsheet. I am using php-excelreader from: [url]http://sourceforge.net/projects/phpexcelreader/[/url] Here is what I have thus far: [code=php] <?php require_once 'reader.php'; $Host = "..."; $User = "..."; $Password = "..."; $DBname = "..."; $Link = mysql_connect ($Host, $User, … |
 | hi all , new to database, how to design these table in mysql. Permissions for CRM 1. Broker /Team a. Add agents b. Assign agents c. Add/Edit everything any agent has 2. Agent a. Can NOT add agents b. Can NOT assign agents c. Only add/edit their own leads any … |
| | Hi I'm just starting with php programming and need some help. This is just a test script I'm writing to see how it works. I'm trying to search for phone of a certain make and price using a different search box for Make and price. I want the results to …  |
| | I had created a registration page for users to sign up an account and a database to store all information such as username and password. I had also created a login page for users to login after registering an account. How do I link the database so that I will … |
| | Please help me out her, I am building a website using wordpress I have created a post with four different categories in the post page, categories named : Action. Terror, Documentary, and News, and these four named Categories are automatically inserted into one of the eleven tables automatically created by … |
 | Hi guys! I got a problem with my logging in system. I can connect to my database with the code: [CODE]session_start(); include('header.html'); $page_title = 'Home Page'; $mail = $_POST['email']; $password = $_POST['password']; $msg =''; if(isset($mail,$password)){ $con = mysql_connect('127.0.0.1','root',''); if(!$con) { die('Could not connect: '.mysql_error()); } else{ echo "Connected!"; } } … |
| | Dear All, I have been using the MBRWithin function for quite a lot of times. Suddenly I notice on google map this 'POINT(101.11857 4.34475)') is out of the geo fence which I specify but it still give a value of 1 in mysql any reason or tweaking need to be … |
| | i have received an error on adding an information on VB6.0 database is SQL i just use the covert ACCESS to MYSQL code :[ please do help me O_O i received an error "mySQL server has gone away" ...other adding of information seems ok except from this one please do … |
| | I have a large array. Is there an alternate method to check if $value in the array is present in the MySql table vote and if not then insert $value into vote. This is what i am doing currently. Is there a better method? [CODE]foreach($rowids as $value) { $select = … |
| | is there a significant difference between phpmyadmin and mysqlbuddy? i mean does they differ in codes? coz i have to make a website that checks whether the username and password exists in the databse. here is my code for looking up in the databse. [CODE] <?php if(isset($_POST['submit'])) { include 'connection.php'; … |
| | Hi, Can anyone explain to me what does this piece of code mean? [CODE] <roleManager enabled="true" defaultProvider="MySQLRoleProvider"> <providers> <clear/> <add name="MySQLRoleProvider" type="MySql.Web.Security.MySQLRoleProvider, MySql.Web, Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/name" autogenerateschema="true" /> </providers> </roleManager>[/CODE] Whenever i run the program, there is this error message that prompted in my web browser Parser Error … |
| | we have our system running but our system needs to be modified because we did something wrong...we are doing an "Internet monitoring System" in our school library where the user can only access the internet 1hr a day, and he/she cannot use the internet within that day if he couldn't … |
 | Hello first code I need to know the code to get data from mysql table that have a letter a i mean i have a table called "Games" there's a games start with a b c d e f g h I need to retrieve games That begin with (( … |
| | Hi all, just wondering what the best way is to structure time in sql database. For example, at present i use this format ; 19/08/2011 (which is day/month/year). when i call this in a sql statement, it shows all results, but not in a chronological order. Can any body solve … |
 | Hi I just set up my IP Board. Now i want to retrieve some of the data via mysql, so far I have no problem getting a table into a datagridview, but what do i do to get a value from a table right now i got SELECT * FROM … |
| | Hello, I think I made a mistake while connecting my tables with foreign keys :S here's the DB- table 1: [U]Id[/U],[U] year[/U],..... (2 Primary keys) table 2: [U]tbl2Id[/U], ... now the table that connects tbl1 and 2 with m..m relation- table 3: [U]Id[/U],[U] year[/U],[U]tbl2Id[/U] I set the foregn keys for … |
| | I am facing problem on sum of dynamic array value. For example : [B]tablename : totalamt[/B] ref_no | Amount 1 | 58 2 | 12 3 | 11 i am using check box to select the ref_no. now i am selecting 3 check box now and submit it. Now it … |
 | Okay so me and a friend of mine are discussing the following: If you have 1. a table with 10 fields, each a varchar(255) or 2. a table with 10 fields, each a varchar(1billion) [B]Which would be better, performance wise?[/B] I say it won't matter, because MySQL reads the field … |
| | I'm trying to creat a search procedure that will search table game and return all rows where columns title, description, platform, and gameid are LIKE parameter searchtext. This parameter is coming from many different pages as a Session("searchtext"), and I'm using a UserControl to send the Session, all pages in … |
| | Good day. I'm new here and I'm nt sure this post should belong in here or not. I had done my programming on the virtual machine while having mysql database set up in my PC. I was unable to get the data from my PC unless I installed another database … |
The End.