Recent content by yahoo182

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!