Re: mysql problem [modified] - Database Discussion Boards

Re: Maintain max x records

Eduard Keilholz2-Dec-10 1:05

Eduard Keilholz

2-Dec-10 1:05

Cool, i'll take a peak, thanks a lot!

.: I love it when a plan comes together :.
http://www.zonderpunt.nl

best way to return is_exists

Jassim Rahma29-Nov-10 22:35

Jassim Rahma

29-Nov-10 22:35

I am using C# with mySQL.

I want to know what's the best way to return is_exists value? I use to that with RETURN 999 in SQL Server and handle the value in SqlParameter.ReturnValue

ca you please guide..

Thanks

default blob

Jassim Rahma29-Nov-10 22:30

Jassim Rahma

29-Nov-10 22:30

I have a blob field in mySQL database to store images.

Is it possible to assign a default blob so a specific image will be the default?

how?

Re: default blob

David Skelly30-Nov-10 1:45

David Skelly

30-Nov-10 1:45

BLOB columns cannot have a default value in MySQL as far as I am aware.

mysql problem

mylogics28-Nov-10 23:16

mylogics

28-Nov-10 23:16

hi am using stored procedure to submit a registration form.
i have checked lot of time but get the same error can yuo plz guide me.
Message = "Key cannot be null.\r\nParameter name: key"

Re: mysql problem

Jörgen Andersson28-Nov-10 23:49

Jörgen Andersson

28-Nov-10 23:49

The message can't be much clearer than that. You're trying to insert a null value into a key column.

To help you further we need more info, such as the table structure, the stored procedure and how it's used.

"When did ignorance become a point of view" - Dilbert

Re: mysql problem

RaviRanjanKr29-Nov-10 0:07

RaviRanjanKr

29-Nov-10 0:07

mylogics wrote:
i have checked lot of time but get the same error can yuo plz guide me.

I am not getting your problem, please be clear about your question.
Provide code which throws exception and what exception you are getting.

we can justice with your question when you did first
Smile | :)

Re: mysql problem [modified]

mylogics29-Nov-10 0:46

mylogics

29-Nov-10 0:46

i have a stored procedure named insertreg:

DELIMITER $$DROP PROCEDURE IF EXISTS `naukri4u`.`insertreg`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `insertreg`(emailaddress varchar(50),firstname varchar(50),lastname varchar(50),username varchar(50),password varchar(50),conformpassword varchar(50),mobile varchar(50),currentloc varchar(50),prefferedjobloc varchar(50),gender varchar(50),totalexp varchar(50),industry varchar(50),function varchar(50),keyskills varchar(50),highestqual varchar(50),yearofpass varchar(50),institute varchar(50),resumetitle varchar(50),resume varchar(50))
BEGIN
insert into registration(emailaddress,firstname,lastname,username,password,conformpassword,mobile,currentloc,prefferedjobloc,gender,totalexp,industry,function,keyskills,highestqual,yearofpass,institute,resumetitle,resume)
values(emailaddress,firstname,lastname,username,password,conformpassword,mobile,currentloc,prefferedjobloc,gender,totalexp,industry,function,keyskills,highestqual,yearofpass,institute,resumetitle,resume);
END$$DELIMITER ;

i want to submit a regisration form using this stored proc.this registration table have primary key reg_id which auto increments so
i have not taken it in my query.the code i have written is:

public DataSet insert(Common.com_registration objcom_reg)
   {
       registration reg = new registration();
       try
       {
                       DbParameter dbparama0 = DAC.Parameter("emailaddress", objcom_reg.Emailaddress, DbType.String, ParameterDirection.Input);
           DbParameter dbparama1 = DAC.Parameter("firstname", objcom_reg.Firstname, DbType.String, ParameterDirection.Input);
           DbParameter dbparama2 = DAC.Parameter("lastname", objcom_reg.Lastname, DbType.String, ParameterDirection.Input);
           DbParameter dbparama3 = DAC.Parameter("username", objcom_reg.Username, DbType.String, ParameterDirection.Input);
           DbParameter dbparama4 = DAC.Parameter("password", objcom_reg.Password, DbType.String, ParameterDirection.Input);
           DbParameter dbparama5 = DAC.Parameter("conformpassword", objcom_reg.Conformpassword, DbType.String, ParameterDirection.Input);
           DbParameter dbparama6 = DAC.Parameter("mobile", objcom_reg.Mobile, DbType.String, ParameterDirection.Input);
           DbParameter dbparama7 = DAC.Parameter("currentloc", objcom_reg.Currentlocation, DbType.String, ParameterDirection.Input);
           DbParameter dbparama8 = DAC.Parameter("prefferedjobloc", objcom_reg.Prefferedjobloc, DbType.String, ParameterDirection.Input);
           DbParameter dbparama9 = DAC.Parameter("gender", objcom_reg.Gender, DbType.String, ParameterDirection.Input);
           DbParameter dbparama10 = DAC.Parameter("totalexp", objcom_reg.Totalexp, DbType.String, ParameterDirection.Input);
           DbParameter dbparama11= DAC.Parameter("industry", objcom_reg.Industry, DbType.String, ParameterDirection.Input);
           DbParameter dbparama12= DAC.Parameter("function", objcom_reg.Function, DbType.String, ParameterDirection.Input);
           DbParameter dbparama13= DAC.Parameter("keyskills", objcom_reg.Keyskills, DbType.String, ParameterDirection.Input);
           DbParameter dbparama14= DAC.Parameter("highestqual", objcom_reg.Highestqual, DbType.String, ParameterDirection.Input);
           DbParameter dbparama15= DAC.Parameter("yearofpass", objcom_reg.Yearofpassing, DbType.String, ParameterDirection.Input);
           DbParameter dbparama16= DAC.Parameter("institute", objcom_reg.Institute, DbType.String, ParameterDirection.Input);
           DbParameter dbparama17= DAC.Parameter("resumetitle", objcom_reg.Resumetitle, DbType.String, ParameterDirection.Input);
           DbParameter dbparama18= DAC.Parameter("resume", objcom_reg.Resume, DbType.String, ParameterDirection.Input);
           DbParameter[] dbparamcoll = new DbParameter[] {dbparama0,dbparama1,dbparama2,dbparama3,dbparama4,dbparama5,dbparama6,dbparama7,dbparama8,dbparama9,dbparama10,dbparama11,
           dbparama12,dbparama13,dbparama14,dbparama15,dbparama16,dbparama17,dbparama18};

           DbParameter dbParam0 = DAC.Parameter("v_userid", objcom_reg.Emailaddress, DbType.String, ParameterDirection.Input);
           DbParameter dbParam1 = DAC.Parameter("v_headline", objcom_reg.Emailaddress, DbType.String, ParameterDirection.Input);
           DbParameter[] dbParamColl = new DbParameter[] { dbParam0, dbParam1 };


           return DAC.SelectDS("insertreg", dbparamcoll);

       }
       catch(Exception exp)
       {
           throw exp;
       }

i am passing a object which is initialized with all the values from my registration form.i am calling this insert function
at my registratin form.hope now u r clear with my prob.

modified on Monday, November 29, 2010 6:59 AM

Re: mysql problem

Mycroft Holmes29-Nov-10 0:53

Mycroft Holmes

29-Nov-10 0:53

Put a break point in the code and check each objcom_reg. value, see if a string value is not initialised and is therefore null.

Never underestimate the power of human stupidity
RAH

Re: mysql problem

mylogics29-Nov-10 0:58

mylogics

29-Nov-10 0:58

i have chechked several time sthe code is correct.evwerythinworks finebut the error comes
at line:

return DAC.SelectDS("insertreg", dbparamcoll);

afterb this line the control skip to exception block.

Re: mysql problem

Luc Pattyn29-Nov-10 2:54

Luc Pattyn

29-Nov-10 2:54

and what are dbparama2,dbparama3,dbparama4,dbparama5,dbparama6,dbparama7,dbparama8,dbparama9,dbparama10,dbparama11,dbparama12,dbparama13,dbparama14,dbparama15,dbparama16,dbparama17,dbparama18?

Confused | :confused:

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Re: mysql problem

Mycroft Holmes29-Nov-10 3:33

Mycroft Holmes

29-Nov-10 3:33

Hasn't really worked out the array thingy yet!

Never underestimate the power of human stupidity
RAH

Re: mysql problem [modified]

Jörgen Andersson29-Nov-10 4:44

Jörgen Andersson

29-Nov-10 4:44

<edit>~~You are setting dbparamcoll twice but with different parameters. The first setting is never used.~~</edit>
Ok, it's official, I'm blind like a bat.

"When did ignorance become a point of view" - Dilbert

modified on Monday, November 29, 2010 11:18 AM

Re: mysql problem

Luc Pattyn29-Nov-10 5:03

Luc Pattyn

29-Nov-10 5:03

actually there are two arrays with different casing, and it is the second one that isn't used.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Re: mysql problem

Jörgen Andersson29-Nov-10 5:16

Jörgen Andersson

29-Nov-10 5:16

Crap, That's a sign that I need to go home now.

"When did ignorance become a point of view" - Dilbert

Re: mysql problem

RyanEK29-Nov-10 14:47

RyanEK

29-Nov-10 14:47

I suspect your insertreg procedure is not providing a value for a key column.

Restrict characters on oracle

padmanabhan N28-Nov-10 21:22

padmanabhan N

28-Nov-10 21:22

Experts,

In my oracle database i have a column "Description". I have to show only 25 characters while writing the select command. Is there any way for that or i have to use cursor

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

Re: Restrict characters on oracle

Goutam Patra28-Nov-10 21:25

Goutam Patra

28-Nov-10 21:25

You mean oracle Substr[^] function

TSQL to print the content/inside of stored proc, definition of view and tables?

devvvy28-Nov-10 15:19

devvvy

28-Nov-10 15:19

hello

TSQL to print the content/inside of stored proc, definition of view and tables?

The idea is to automate detection of any changes to stored proc or view/table schema.

Thanks

dev

Re: TSQL to print the content/inside of stored proc, definition of view and tables?

Mycroft Holmes28-Nov-10 17:08

Mycroft Holmes

28-Nov-10 17:08

Uhm it's called source control and there are a vast number of systems built to meet this need. And they almost all cost money.

Otherwise you can look into the system tables and possibly the schema views, all the procedure scripts are in there. You can write then out or copy them to another table where you could simply do a != comparison on the relevant fields.

Never underestimate the power of human stupidity
RAH

Re: TSQL to print the content/inside of stored proc, definition of view and tables?

Goutam Patra28-Nov-10 20:32

Goutam Patra

28-Nov-10 20:32

You may use
1. information_schema.columns for columns
2. information_schema.tables for tables
3. sp_helptext 'sp_procedurename' for SP Text

reset primary key (mysql)

Jassim Rahma28-Nov-10 2:56

Jassim Rahma

28-Nov-10 2:56

I have a primary key in StudentTable in mySQL database called (schoolDB)... I was using it for testing and now i want to rest the primary key to start from 1

how can I do that?

Re: reset primary key (mysql)

Estys28-Nov-10 3:17

Estys

28-Nov-10 3:17

Try this :

ALTER TABLE yourTable AUTO_INCREMENT=1

Be sure to delete all rows first.

Cheers

^I _don't like ^my _signature at ^all

Re: reset primary key (mysql)

Luc Pattyn28-Nov-10 3:21

Luc Pattyn

28-Nov-10 3:21

1. http://www.google.com/search?q=mysql+reset+primary+key[^]

2. IMO it should not matter; a primary key has one and only one function: it needs to be unique, it does not matter what the values actually are.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Re: reset primary key (mysql)

Jörgen Andersson28-Nov-10 10:21

Jörgen Andersson

28-Nov-10 10:21

You're oversimplifying things a bit in my opinion.
It does need to be unique, and it does not matter what the values actually are if you are using surrogate keys.
But there is such a thing as natural keys, and there's nothing wrong in using them if it fits the model.

Here[^] is yet another article on the subject by Joe Celko.

"When did ignorance become a point of view" - Dilbert

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.