Search results for query: *

Hi there, I am pretty new to asp.net can anyone tell me how extract a variable form a webrequest, say if i have http://www.domain.com/test.aspx?value1=abc&value2=xyz thanks! :)

hi there, I want to return an xml document from a cs.net file. Can anyone point me to the standard .net libraries that I can use in order to do this? Much appriciated, :)

Hi there, mysqldump over network is working just fine like the following. mysqldump -ukzu -p jokes | mysql -h 192.168.1.190 -ukzu -p jokes I was wondering how I would copy a table in "jokes" instead of the whole db. Say if my table name was named "people" in the jokes table. Thanks! :)

Hi there, in the following code, I am trying to connect to my sql server from C# aspx code. However, when I run it, i seem to get the following error. In my sql server security/login setting, I have testuser to access the Northwind db and permit db role as public. any sort of input is...

Thanks for the help guys. Yes MS SQL server takes single instead of double quotes it seems. It worked out just fine. I will be more careful where I post my stuff. I wasn't too sure coz this was sort of a Q that relates to both my/ms sql. thanks

Hi there, I have a c sharp file that reads in a text file and add the fields to my MYSQL server db. My table is defined as: "CREATE TABLE images(hotelID int, Name varchar(40), Caption varchar(20), URL varchar(100), Supplier varchar(20), Width int, Height int, ByteSize int, ThumbNailURL...

Actually I tried that already as follows but It still gives me the same result. if exists(select table_name from INFORMATION_SCHEMA.TABLES where table_name='images') DROP TABLE 'images' Unhandled Exception: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'images'. at...

after going through some websites, I think it should be string sql = "if exists(select table_name from INFORMATION_SCHEMA.TABLES where table_name = " + tableName + ") DROP TABLE " +tableName ; but still I get an error saying that if exists(select table_name from...

humm it seems to give me this newline in constant error if I have new lines within the string definition.... addImagesMssqlDB.cs(21,21): error CS1010: Newline in constant addImagesMssqlDB.cs(26,1): error CS1010: Newline in constant

and when I execute that code, I get the following error.. Unhandled Exception: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '<'. Line 1: Incorrect syntax near '<'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Test.Main()

Hi there, Thanks for the quick feedback. Say if I wanted to put this in a string variable, how would I go about doing this? So far I have dbcon = new SqlConnection(connectionString); dbcon.Open(); IDbCommand dbcmd = dbcon.CreateCommand(); string sql = "if...

Hi there, I am currently porting a code form Mysql to MSSQL, In mysql the following sql statement works fine: "DROP TABLE IF EXISTS "+tableName but when I run it against MSSQL, they are saying that they dont allow an IF there: Does anyone know how I should go about implementing this? Thanks :)

Hi there, i'm tryng to write a script for this command. Do you know how I can embed the $1 argument into the sed command? My command will be something like: showline.sh 3 test.txt !/bin/sh line=$1 file=$2 sed -n '"$line"p' $2

Thanks PHV. That was just the command I needed! :)

Hi there, I know in Unix, the head command can be used to show the first few lines of a file. However, what if we want to show only a specific line of it. Say if we wanted to show line 5 of a file named test.txt, is there any command that does this? thanks!

Thanks!!! that did the tick. I used the old_password() method to revert the pw format in my newer mysql. Thanks!

Hi there, This is what I get for the following message. db connect error:Client does not support authentication protocol requested by server; consider upgrading MySQL client In this case, what is Client referring to? Is it my browser or my php version? or is it the MySQl that is installed on...

When I access the php file with a browser, I get the reply "Unable to connect to the database server at this time" Is there anyway I can find out what went wrong more precisely? Thanks, and sorry bout the vague description ... !

Hi there, I have a script that splits the fileds seperated by a special character. The code works fine when the character is , but does not when I have a textfile seperated by | My code is as follows. Can anyone give me some hints ? Thanks :) open(FILE, "test.txt") or die "$!"; my $string...

This works in apache but for some reason not in IIS6 (windows2003). I am using PHP4.* on both systems. I have tried the IP address instead of localhost but I still get the same reasult ..... any input will be much appriciated. Thanks! // establish db connection $dbcnx =...