6,934 Topics
 | |
| | I've used SQL authentication and windows authentication in my connection strings to SQL server just fine. I've got a login form that the user has to put their username/password in and it verifies to AD to ensure that is who it is and then logs in. Currently it is set … |
| | Hey, I'm currently using mysql_real_escape_string() to protect against SQL injection. Is there a way to exploit this? I have already tried \ to try to make the query \', thus making it just a regular backslash. I have heard of the Big5 exploit, but I don't know how to use …  |
| | How can I get SQL Date and time into statusstrip with timeer control |
| | I have been developed shareware software name [B]DBEXform[/B] to design forms and reports for different databases, with integrated Sql query builder. Basic functions in software are quite easy to use. Now it seems that potential larger users likes it, but they afraid to use is because lack of a local … |
| | I am new to c# so please don't laugh at me :icon_biggrin: i have a database called database1 in my program , when i create a setup file and lunch it in another computer because the database isn't attached i will get many errors , how can i attach it …  |
| | Hi I want to display the data from database, in graphical manner, Can anyone suggest an idea. for eg: Piechart for productivity of a company. Name Productivity rahul 200 ramesh 345 raj 429 Thanks |
| | Guys , I have some questions 1) lets say that im developing a asp.net site using VS 2008 , how do i use sql server 2005 as the database 2) I have using MS-ACCESS as the database before and it was easy , all had to do was to create … |
| | Hello , i have two tables ,animal ,which has name,familie and weight and table food which has feed. I want to assure that every animal has at least one food. I did this : [CODE]import mysql.connector from database import login_info db=mysql.connector.Connect(**login_info) cursor=db.cursor() data=[('Geo','Elephant',['hay',peanuts']), ('Gerald','Gnu',['leaves','shoots']), ('Leo','Leopard',['meat']) ...................... ] for name,familie,feed in … |
| | [URL="https://docs.google.com/document/d/1bXZixHNn4gsjU4ZxmaMIhicewVApoJpEbE_Yb3SOAYI/edit#"]https://docs.google.com/document/d/1bXZixHNn4gsjU4ZxmaMIhicewVApoJpEbE_Yb3SOAYI/edit#[/URL]  |
| | SELECT * , 3956 *2 * ASIN( SQRT( POWER( SIN( ( 122.4058 - ABS( dest.lat ) ) * PI( ) /180 /2 ) , 2 ) + COS( 122.4058 * PI( ) /180 ) * COS( ABS( dest.lat ) * PI( ) /180 ) * POWER( SIN( ( 37.7907 - …  |
| | I have a datagridview which allows the user to select multiple rows of a table.Now i have to take the values of one column of all the selected rows and insert those into the sql table.how do i do that? |
 | Hello, basically I have two tables: People Orders Now I want to grant the first person in "Peoples" with all privileges, now I've tried to do this: [code] GRANT ALL ON Orders TO {testUser |PUBLIC |role_name} [WITH GRANT OPTION]; [/code] Doesn't work (because they are technically not a user, therefore, … |
| | I have this query, but the ordering by is not working. It should order by value, but doesn't react. you'll see what I mean in the code. [ICODE]<table class="pme-main"> <tr> <th class="pme-header">Bestemming</th> <th class="pme-header">Naam Klant</th> <th class="pme-header">Aantal Manden</th> <th class="pme-header">Aantal Duiven</th> <th class="pme-header">Naam Bestemmeling</th> </tr> <?php $con = mysql_connect("****","****","****"); if … |
| | Again guys here is same problem. Please check this code. Everything is OK. But sql data does not show up. <?php /*Set to error level to development modes*/ ini_set("display_errors", 1); error_reporting(E_ALL); if ( isset($_POST['username'])) { $ret = add_to_database(); if (!$ret) { print "Error: Database error"; } else { print "Welcome … |
| | Iam developing a small school software. I want to show fees of every student of whole year. Like John(student) I want show his fees that every month he paid at what date and how much. So how should I start please help..  |
| | In going through some homework, I was able to do some of the problems, but not others. For example, one problem was "Produce a list of employee last name, first name, job function, department name and department location. Use appropriate, user friendly column aliases." I finished this with this code: … |
| | Hey, I'm currently using mysql_real_escape_string() to protect against SQL injection. Is there a way to exploit this? I have already tried \ to try to make the query \', thus making it just a regular backslash. I have heard of the Big5 exploit, but I don't know how to use … |
| | hi, this is relating to a wordpress site, i have this query [CODE]$qstring="SELECT * FROM rwb_bk_schedule s INNER JOIN rwb_bk_rooms r ON s.room_id = r.room_id WHERE s.room_status=1 AND r.room_name='".$room."' AND start_date BETWEEN '".$sdate."' AND '".$edate."' OR end_date BETWEEN '".$sdate."' AND '".$edate."'";[/CODE] as i given the code i use OR there … |
| | I am beginner and this is my [B]first project[/B] (happy face). I am trying to make log in systen to learn php and mySQL. At first everything was working so and then i decided to rewrite everything in [B]Object oriented[/B] code and then it is not working. Since it is … |
 | I just thought I would re-iterate something that I have mentioned a few times in my replies to threads on here in that if your code isn't working, one of the first things to do is actually test your query in the database (i.e. through phpMyAdmin). The reason I am …  |
| | dear all, [CODE]$member_id = $_POST['member_id']; $delete = 'yes'; $HOST = 'localhost'; $USERNAME = 'root'; $PASSWORD = ''; $DB = 'hrs'; $link = mysqli_connect($HOST, $USERNAME, $PASSWORD, $DB); $query = "UPDATE member SET delete='$delete' WHERE member_id='$member_id'"; echo $query; $result = mysqli_query($link, $query) or die(mysqli_error($link)); [/CODE] Any error in my query? it says … |
| | Hi everyone, I have made a script which logs the users ip into a table. Here is the table: [CODE] ID - PKEY A.INC IP - VARCHAR ENTERED - TIMESTAMP [/CODE] What I would like to happen is that after a row has been inserted, I want to set up … |
| | Dear Team, I have a question regarding LINQ 2 SQL and data integration with textbox: I have one textbox and button on my form, one stored procedure and LINQ 2 SQL class file in my project, I want that when I hit button, my store procedure run the SQL query …  |
| | Hi, I have a combobox and a datagridview bound to a table in my database.The combobox shows the "ID"s and i want to display a complete row in the gridview based on a selected id in the combobox.  |
| | Hello, I am getting the contents on my website from database using SQL Stored Procedure (C#). Now, I want to change the output look with XML / XSLT. How can I do this? Something like this http://forums.asp.net/t/1230093.aspx/1 but am not sure how to go about it, am new to C# … |
| | Hey everyone! I am working on a project that involves querying a mysql database using php, and I am running into some issues. html form is in list_files.php and the query is in query.php .. i also attached my mySQL database which has 2 tables: only the file table is … |
| | Hi Everyone- We are building a database that needs table(purchaser) to check table(paypal) for a matching telephone number. Table(paypal) has 'purchaser telephone' as PK and table(purchaser) has 'purchaser telephone' as FK. I can insert and see the data in both tables, but running a select query returns an empty result. … |
 | Hello, I have one more question. I am connectinag to SQL Server 2008, not express, and I keep getting the "login failed for user "..."" The connection string I am using is: [CODE] Dim connStrg As String = "Data Source=" _ & ServerAdressTextBox.Text & _ ";Initial Catalog=" & _ DatabaseNameTextBox.Text … |
| | How do I populate data in both tablefoot and tablebody by getting values from an sql database. For example, the data in tablefoot refers to the date and tablebody refers to the values that belong to that date. I am confused about how this kind of tables work. Thanks in … |
| | Hello :) i intend to make a game in c# that will contain information of 10,000 people i dont familiar with db yet but i guess from a little reading that the best way is to use ADO.NET sql library... the game is not on the internet, it will be … |
| | 1.Procedure named *ship_order* that will accept an order# parameter. It should verify that the ship date for the order# is null and each book ordered has a sufficient quantity on hand. If every book is available, the quantity on hand for each book should be decremented and the ship date … |
| | Hello, I am creating a web server which lets me insert into a table. The user invokes the specific ID and its meant to append to the table with that ID, startdate and an enddate. [CODE] <WebMethod()> _ Public Function reserveVehicle1(ByVal vID As Integer) As Boolean Dim strInsert As String … |
| | Hi i have 2 tables: film - filmid, filmname review - id, reviewtitle, filmreview, filmid i basically want to search for a film name thats in the film table then retrieve the review from the review table that matches the film, the match is found using the filmid as the … |
| | dear all i have 2 tables, one is project table and another replies table. [ICODE]"SELECT * FROM project, replies WHERE replies.member_id=$_SESSION[member_id] AND project.project_id=replies.project_id ORDER BY project.project_id "; [/ICODE] the above code gives me all , but I need the latest updated replied in each project id I tried [CODE]SELECT * … |
| | I am trying to build a login page in asp.net with sql as backend , when i enter the username and password and click the submit , nothing happens.. Please help this is my *.aspx.vb file........ Imports System.Data.SqlClient Imports System.Data Partial Class login1 Inherits System.Web.UI.Page Protected Sub TextBox1_TextChanged(ByVal sender As …  |
| | Dear All, I got one table as the tblMasterData then I left join it with another table like this tblEventAlert. So what I want to do if there is a match between tblMasterData and tblEventAlert then for that tblEventAlert I would like to match it with tblDevice to to get … |
| | I am facing the problem when i m attaching the ms sql 2005 database file in win7... MICROSOFT SQL SERVER ERROR 5120 |
| | I am unable to restore .bak file in sql server 2005 ,Although i took back up from sql server 2005 and restore in the same version,its giving me an error ... does any one thing think that .bak is corrupted or whatever... please give me any remedy in that case …  |
| | I'm working on a program that allows me to quickly write database entries. There are 123 columns, almost all of them I'm not using right now so I figured I'd write a program to speed up the process of adding entries to the database. The problem I'm having is exporting … |
 | heres a form i have created. its a search form. [url]http://img266.imageshack.us/img266/722/paymentsh.jpg[/url] it searches and lists the results in list view. heres my mssql query : [CODE] select transactions.trans_id,transactions.cust_id,transactions.trans_amount," _ & "transactions.trans_date,customers.fname+' '+ customers.lname as customer from transactions inner join customers on transactions.cust_id=customers.cust_id " _ & "where trans_type='inv' and (trans_id= " … |
| | I am making an invoice system. Please have a look at the images. [url]http://img32.imageshack.us/img32/9216/capture1iv.jpg[/url] [url]http://img839.imageshack.us/img839/1228/capture2cq.jpg[/url] as you can see, the place order button is creating an invoice. I have actually created a junk table and a junk column in it just to setup the invoice_id and load it when "invoice … |
| | Hi, Is there any tool available to convert sql CE db (*.sdf) file to SQLITE db?. I got some from code project but it converts only SQL Server DB. -anoop |
 | I used to write PL/SQL programs in oracle 9i.Since windows 7 doesnt support it, switched to oracle 10g express edition. All my SQL programs are alright. But I cant put mutiple queries on a single run though. Like insert into many rows. But PL SQL programs are going crazy. Too … |
| | I am making a DBMS using C#.Net and MS SQL. i want to display the data using crystal reports. In the Database Fields when the Database Expert wizard opens after choosing OLE DB (ADO) and then OLE DB for SQL provider, i have to give the Server, user & password … |
| | Hey Guys, Ive got a MyBB forum and im looking at making a plugin to see what day had the most posts. In theory ive worked out how to do it, but I cant put it down in code. In the MyBB stats table (mybb_stats), I have a dateline (unix …  |
| | [CODE]<?php include 'connection.php'; $qry = mysql_query( "SELECT g.totalDaily, p.COUNT(DISTINCT bodyNo) AS qty FROM grandTotal AS g, paintshop AS p ") or die('error'); while ($rows = mysql_fetch_array($qry)){ ?> <td><?php $dpu = $rows['g.totalDaily'] / $rows['qty']; echo $dpu;?></td> <?php } ?>[/CODE] i want to display the $dpu which is defect per unit..the information … |
| | This is homework. I have to create two tables with certain constraints. However, I keep getting syntax errors, and I really have no clue exactly how to format it because there are so many different 'templates' out there. Here is what I have so far. [CODE] create table Departments (Department_ID … |
 | Hey guys next question :(. Now I have having troubles with the IMAGE data type, can anyone provide examples on how to retrieve and update the image? I have tried the following: [CODE] [size=2][/size][size=2][color=#0000ff]Dim[/color][/size][size=2] imgdatastream [/size][size=2][color=#0000ff]As[/color][/size][size=2] FileStream [/size][size=2][color=#0000ff]Dim[/color][/size][size=2] imgdatalen [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]Integer [/color][/size][size=2][/size][size=2][color=#0000ff]Dim[/color][/size][size=2] imgtype [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]String [/color][/size][size=2][/size][size=2][color=#0000ff]Dim[/color][/size][size=2] n [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]Integer [/color][/size][size=2]imgdatastream … |
| | I've my data in a Database. Using SQL,I need to print it on a list For example, My Table is: Teachers, and it has ID, Name and Phone#. I need a button which shows all this data in a list. My first thought is with a DataGridView.. ID Name Phone … |
 | hey everyone, i need a little help in here....i am making a vb program( VS 2008 ) that create a blood type Card for a patient(Name,ID,BirthDate.....and picture), All info are stored in SQL database (SQL 2008), concerning the image i store the path of it....so in the crystal report how … |
The End.