Jump to content

Check out our Community Blogs


Member Since 14 Nov 2009
Offline Last Active Aug 22 2012 09:18 PM

Posts I've Made

In Topic: ASP problem with PlaceHolder

20 August 2012 - 10:16 PM


Thanks for your help ! i have been searching for the solution half of yesterday and i didnt meet any UpdatePanel reference ( i am just starting with asp so i didn't even knew this exists..)
Anyway now it works great, thanks again for your help !


In Topic: JDBC problem again

25 January 2012 - 12:40 AM

wim DC your help is priceless right now i used null without ' and it works great, after i will back from university i will check preparedStatement, once again thank you very much, you are the master !

In Topic: JDBC problem again

24 January 2012 - 05:33 PM

i create table like:
Create table copy (
      id_copy Integer NOT NULL ,
      id_purchase Integer NOT NULL ,
      id_publisher Integer ,
      id_book Integer,
      id_map Varchar2 (20),
      id_comix Varchar2 (20),
      id_painting Varchar2 (20),
      id_autor Integer NOT NULL ,
      price Varchar2 (20),
      condition Varchar2 (20),
  PRIMARY KEY (id_copy ),
  FOREIGN KEY (id_purchase ) REFERENCES purchase(id_purchase ),
  FOREIGN KEY (id_publisher ) REFERENCES publisher(id_publisher ),
  FOREIGN KEY (id_book ) REFERENCES book(id_book ),
  FOREIGN KEY (id_map ) REFERENCES map(id_map ),
  FOREIGN KEY (id_comix ) REFERENCES comix(id_comix ),
  FOREIGN KEY (id_painting ) REFERENCES painting(id_painting ),
  FOREIGN KEY (id_autor ) REFERENCES autor(id_autor )
) ;

General idea is that i can make copy of only 1 object (from book,comix,map, painting). When i enter only id_book value everything is ok. But when i try to enter only id_map or id_comix or id_painting ive got exceptions, bellow i ll paste the way i use statements:
String insertString1 = "insert into egzemplarz values("+i+","+purchase+", "+s3+", "+s4+", '"+s5+"', '"+s6+"', '"+s7+"', "+s8+", "+s11+", '"+s10+"')";                    stmt = aa.conn.createStatement();

where i,s1,...,s10 are strings which i obtain by get.Text() method from textfield.

i CRY for some help ://

ps. sorry for my english

edit 1: pools id_book, id_map, id_comix and id_painting are NULLABLE

In Topic: JDBC statement problem

18 January 2012 - 11:29 PM

for example
i = 1
s1 = 111
s2 = 1111
s3 = 2012/01/01
s4 = 123

In Topic: JDBC statement problem

18 January 2012 - 01:58 PM

String insertString1 = "insert into WYNAGRODZENIE values("+i+" , "+s1+" , "+s2+" , '"+s3+"' , "+s4+")";

problem is the same...

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download