Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by yahoo182

  1. yahoo182

    getting variable from web request

    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! :)
  2. yahoo182

    returning an xml file from c#.net

    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, :)
  3. yahoo182

    mysqldump over netowrk: copy table instead of entire network

    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! :)
  4. yahoo182

    connect to sql server form aspx

    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...
  5. yahoo182

    empty object or column names error

    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
  6. yahoo182

    empty object or column names error

    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...
  7. yahoo182

    if exists function in MS SQL

    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...
  8. yahoo182

    if exists function in MS SQL

    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...
  9. yahoo182

    if exists function in MS SQL

    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
  10. yahoo182

    if exists function in MS SQL

    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()
  11. yahoo182

    if exists function in MS SQL

    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...
  12. yahoo182

    if exists function in MS SQL

    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 :)
  13. yahoo182

    command to output a specific line in a file

    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
  14. yahoo182

    command to output a specific line in a file

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

    command to output a specific line in a file

    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!
See more

Part and Inventory Search

Back
Top