& its another 43 dreams

• hisoka

  27 Apr 06, 13:36

  Originally posted by ndmmxiaomayi:

  Can't find anything useful in the websites.
  
  How to put hyphen?
  
  Because I need to write the ISBN. Or can I just not put the hyphen?

  isbn got hyphen no hyphen, hypehn where also doesn't matter one. its the numbers and letter tat matter
• ndmmxiaomayi

  27 Apr 06, 13:37

  Originally posted by rainee:

  cannot just put the hyphen inside the quotes? like '1244-4455-66' ?

  Put liao. Then error.
  
  Delete the hyphen don't have this error, but got another error.
• ndmmxiaomayi

  27 Apr 06, 13:39

  Originally posted by hisoka:

  isbn got hyphen no hyphen, hypehn where also doesn't matter one. its the numbers and letter tat matter

  Ok. I deleted it liao.
• rainee

  27 Apr 06, 13:44

  Originally posted by ndmmxiaomayi:

  hmm...did u use the same syntax as wat u used the other time when it worked?
• rainee

  27 Apr 06, 13:45

  Originally posted by ndmmxiaomayi:

  Put liao. Then error.
  
  Delete the hyphen don't have this error, but got another error.

  wat error did you get?
• hisoka

  27 Apr 06, 13:46

  i think prob hyphen is a special symbol either need to use library or must use number????
• ndmmxiaomayi

  27 Apr 06, 13:47

  Originally posted by rainee:

  hmm...did u use the same syntax as wat u used the other time when it worked?

  Same syntax. Don't know what's wrong leh...
  
  I re-do the whole table liao. Always get until this part then error.
• rainee

  27 Apr 06, 13:50

  Originally posted by ndmmxiaomayi:

  Same syntax. Don't know what's wrong leh...
  
  I re-do the whole table liao. Always get until this part then error.

  u mean when you try to enter the hyphen?
• ndmmxiaomayi

  27 Apr 06, 13:50

  Originally posted by rainee:

  wat error did you get?

  The error you just quoted me.
• ndmmxiaomayi

  27 Apr 06, 13:51

  Originally posted by rainee:

  u mean when you try to enter the hyphen?

  With and without.
• rainee

  27 Apr 06, 13:52

  wa i oso dunno how to help le...one thing is cos u use mysql query browser...when i enter everything inside the mysql it can create table and rows just fine...
  
  not sure abt the hyphen tho, for now i tink just enter all numbers...i see if i can figure out sth and help u later...
  
  now neeed to go study for my Math exam le...
• rainee

  27 Apr 06, 13:54

  Actually mayi, can you post up the codes you already wrote? i mite be able to spot mistakes from there
• ndmmxiaomayi

  27 Apr 06, 13:58

  CREATE TABLE COMIC_MASTER
  (
  ISBN VARCHAR(10) NOT NULL,
  TITLE VARCHAR(90),
  PUBLISHER VARCHAR(30),
  COMIC_LANGUAGE VARCHAR(10),
  PRICE INT,
  PRIMARY KEY(ISBN)
  );
  SELECT * FROM COMIC_MASTER;
  DESC COMIC_MASTER;
  INSERT INTO ( ISBN, TITLE, PUBLISHER, COMIC_LANGUAGE, PRICE ) VALUES ("0123678930", "CONDOR HEROES", "DA Q", "CHINESE", "15");
• hisoka

  27 Apr 06, 13:58

  hmm pity i dunno this type of stuff cannot help
• rainee

  27 Apr 06, 14:00

  Originally posted by ndmmxiaomayi:

  CREATE TABLE COMIC_MASTER
  (
  ISBN VARCHAR(10) NOT NULL,
  TITLE VARCHAR(90),
  PUBLISHER VARCHAR(30),
  COMIC_LANGUAGE VARCHAR(10),
  PRICE INT,
  PRIMARY KEY(ISBN)
  );
  SELECT * FROM COMIC_MASTER;
  DESC COMIC_MASTER;
  INSERT INTO ( ISBN, TITLE, PUBLISHER, COMIC_LANGUAGE, PRICE ) VALUES ("0123678930", "CONDOR HEROES", "DA Q", "CHINESE", "15");

  hmm i tink i spot sth weird...
  
  INSERT INTO ( ISBN, TITLE, PUBLISHER, COMIC_LANGUAGE, PRICE ) VALUES...
  
  shudnt it be
  
  INSERT INTO COMIC_MASTER ( ISBN, TITLE, PUBLISHER, COMIC_LANGUAGE, PRICE ) VALUES ....
• ndmmxiaomayi

  27 Apr 06, 14:01

  Originally posted by rainee:

  wa i oso dunno how to help le...one thing is cos u use mysql query browser...when i enter everything inside the mysql it can create table and rows just fine...
  
  not sure abt the hyphen tho, for now i tink just enter all numbers...i see if i can figure out sth and help u later...
  
  now neeed to go study for my Math exam le...

  Basically the same as from command line. Only that Query Browser looks nicer.
  
  See you around!
• ndmmxiaomayi

  27 Apr 06, 14:04

  Originally posted by rainee:

  hmm i tink i spot sth weird...
  
  INSERT INTO ( ISBN, TITLE, PUBLISHER, COMIC_LANGUAGE, PRICE ) VALUES...
  
  shudnt it be
  
  INSERT INTO COMIC_MASTER ( ISBN, TITLE, PUBLISHER, COMIC_LANGUAGE, PRICE ) VALUES ....

  
  
  Thanks! My careless mistake.
• rainee

  27 Apr 06, 14:05

  Originally posted by ndmmxiaomayi:

  
  
  Thanks! My careless mistake.

  np
  
  got anymore problem can post here i will see if i can help
• ndmmxiaomayi

  27 Apr 06, 14:08

  Originally posted by rainee:

  np
  
  got anymore problem can post here i will see if i can help

  Will will.
• hisoka

  27 Apr 06, 14:13

  i got a problem, how to write a program to help me make my poster??
  
  i headache abotu it now dunno how to do!!!
• ndmmxiaomayi

  27 Apr 06, 14:17

  Originally posted by hisoka:

  i got a problem, how to write a program to help me make my poster??
  
  i headache abotu it now dunno how to do!!!

  Already got. CorelDraw or Photoshop or Paint.Net
• hisoka

  27 Apr 06, 14:19

  Originally posted by ndmmxiaomayi:

  Already got. CorelDraw or Photoshop or Paint.Net

  i using freehand. but i want one that will do it for me then i no need to think
• ndmmxiaomayi

  27 Apr 06, 14:35

  Originally posted by hisoka:

  i using freehand. but i want one that will do it for me then i no need to think

  Years later. When they can figure out what your brain is thinking.
• rainee

  27 Apr 06, 14:57

  time to go sleep...
  
  have a great day to everyone in here
  
  and to hisoka...i dun tink i know of any program dat will create a poster automatically for u, dats y mine took weeks to be made
• ndmmxiaomayi

  27 Apr 06, 15:00

  Originally posted by rainee:

  time to go sleep...
  
  have a great day to everyone in here
  
  and to hisoka...i dun tink i know of any program dat will create a poster automatically for u, dats y mine took weeks to be made

  Good night rainee! Sweet dreams!