| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> bladhasd: "from users table"? what does that mean??
<1> i have access to another persons table
<1> and i need to copy his data into my table
<1> it says to access another users table you have to prefix the tablename wtih the uers user names i.e. l305_iadh.dog
<1> but how would the whole syntax look like
<1> with
<1> insert into dog (select * from l305_iadh.dog);
<1> like this?
<2> im trying to setup phpCounter. when im trying to load script in mysql i get error #1067 - Invalid default value for 'counter_id'
<2> and thats a counter id counter_id mediumint( 7 ) unsigned DEFAULT '0' NOT NULL AUTO_INCREMENT ,
<1> is there a fast way of deleteing everything inside a table
<1> even if there are constraints to other tables
<1> how can you delete a constraint in a table
<3> litheum: duh.. hehe.. thank you =)
<0> Magos: don't forget that MySQL is a company, too, and they would be happy to sell things to your company :)
<1> can anyone show me how to copy info of a table from one user to ur own table
<0> bladhasd: CREATE TABLE LIKE ... then INSERT INTO ... SELECT ...
<1> the user is l305_iadh
<1> insert into <tablename> (<query>)
<1> what would i write in the query
<1> i want all the info he has
<0> bladhasd: don't use (), there's no need
<0> insert into my_table select * from his_table
<4> bladhasd: You really need to use an explicit field list for both the INSERT and the SELECT.
<1> ERROR at line 1:
<1> ORA-01400: cannot insert NULL into ("L305_SHARMAA"."OWNER"."OWNERID")
<1> yea i got it workign what does that mean the NULL
<1> maybe in my table declaratino
<1> can i do ownerid not null int
<4> bladhasd: You didn't have an explicit field list, causing you to attempt to insert a NULL ownerid. Apparently that field can not be NULL.
<1> so how would i declare in my table
<1> like this ownerid int not null
<1> ?
<4> bladhasd: You want that field to hold NULLs?
<1> i have to match my table declaration with that of the user
<1> thats why it gave me that error
<1> i think because i didnt declare not null
<4> bladhasd: If so, remove the NOT NULL from the column definition.
<1> thats what i had initally
<4> bladhasd: For more direct feedback, post the create table statements for the tables involved, along with the INSERT statement that is failing.
<1> without the not null
<1> but it still gives me the error
<1> ok
<1> http://javanub.net/pastebin/app/view/423
<1> i tried the same without the not null
<1> and it still says cant insert null inside the table
<4> bladhasd: I don't believe you.
<1> do you think
<1> it should be varchar
<4> bladhasd: You didn't post the other create table statement.
<1> http://javanub.net/pastebin/app/view/424
<1> here
<4> bladhasd: You also didn't listen to my previous comments about using EXPLICIT field lists.
<4> bladhasd: You really *must* use explicit field lists.
<4> bladhasd: You posted the same table twice.
<1> the second one is without the not null
<1> im trying to make dog(ownerid,name,phone)
<4> bladhasd: Ok. So now try this again. Make sure you explicitly DROP the wrong table and recreate it properly.
<1> maybe the ordering
<1> is causing the problem
<4> bladhasd: Your description is mistaken. You can't have seen the error you showed with the field specified (without the NOT NULL).
<4> bladhasd: The EXPLICIT field list is required. The ordering is not guaranteed.
<1> ok works
<4> Right. Of course.
<1> i messed up the ordering
<4> Never ***ume field order.
<1> ye ;-) thanks for ur help though
<4> You're welcome.
<1> have you used jdbc before
<1> xgc
<1> im trying to make an interface with swing when querying the stuff
<4> bladhasd: I use JDBC daily.
<4> Except sometimes on weekends.
<1> im having this problem with my jdbc swing application
<1> can u take a look quickly
<4> Sure.
<1> ill pastebin it again
<1> cheers mate
<1> http://javanub.net/pastebin/app/view/422
<1> i have these 3 tables which i will extract from the sql
<1> and i want to put them on a pane
<1> but when i run it i only get a small window
<1> instead of the 3 tables which should be underneath each other which
<4> Ah. A Swing question, not SQL.
<4> One moment.
<1> ye the interface part with the jdbc cheers
<5> #java
<1> hello Xgc have you taken a look
<4> Yes. I'm sure it's a simple issue with layout and component size. Your use of setSize() is probably not going to do the trick.
<1> what could be causing it do you think :-.
<4> bladhasd: This might not be important, but why do you have ... super(new GridLayout(1,0)); ... and then later apply a BorderLayout()?
<1> should i delete that gridlayout
<1> hm where elese coudl it be Xgc
<1> thats casuing the error i mean
<4> bladhasd: Remove the GridLayout() non-sense, remove the add(of all the other fluff in the SimpleTableDemo constructure) and add(new JLabel("This is a test"));
<4> bladhasd: You'll see this works nicely.
<4> bladhasd: So start at this point and build slowly.
<1> its still small the window for some reason
<1> how can i add like 3 tables underneath each other in one main pane
<4> No. This is a window with the correct size to hold the JLabel.
<4> The window/frame will adjust size as you add to the JPanel.
<1> ok
<1> and from there onwards
<1> i put one table in the pane
<1> thats what i try to do then antoher
<1> but
<1> dont know where to start
<1> its still small although i added the label
<4> bladhasd: You can't add more than one component to the SOUTH side of the BorderLayout. You have to add another single container to SOUTH if you wish to stuff more than one component in there.
<1> do i have to do revalidate aft erhat:
<4> bladhasd: You didn't do as I suggested.
<4> bladhasd: I told you *exactly* what I did to get this working.
<1> can u repost what u did
<1> to pastebin
<4> bladhasd: http://javanub.net/pastebin/app/view/425
<1> ok
<1> it adjusted the size
<1> :-)
<1> how can i carry on from there with this container thing u talked about
<4> bladhasd: You need to use the proper layout(s). Note the plural.
<4> bladhasd: If you want to add multiple components to a single area of a BorderLayout, you have to use a subcontainer with it's own layout.
<4> its
<4> bladhasd: Read some of the layour management sections of the tutorial.
<4> layout
<1> k
<1> how would i make the container
<1> it says con1.setLayout(new BorderLayout()); Xgc
<1> http://www.cs.miami.edu/~duncan/spring02/csc120/lecture18.html
<1> hello XGC could you repaste how i could do it with a boxLayout
<1> please
<1> http://examples.oreilly.com/jswing2/code/ch11/HBox.java
<1> i foudn this box layout how would i apply it in my case so that it adds those tables
<1> instead of buttons Xgc
<1> hello XGC
<4> bladhasd: You need to spend some time with the tutorial.
<1> please could you repost where i cuold make the box in my code
<1> so that i can try doing it at that location
<1> pan..setLayout(new BoxLayout(box, BoxLayout.Y_AXIS));
<1> i did this
<1> can i then add my tables inside there?
<4> bladhasd: Practice with JLabels inside the container with layout manager of your choice. There's not much magic here.
<4> bladhasd: Trying to put together the entire mess at once when using layouts you don't understand is a mistake.
<4> bladhasd: Once you get the labels placed properly, just replace them with your tables. It's really that easy.
<4> If any if the tables look badly, you then know it's the table at fault and not your layout.
<4> s/if the/of the/
<1> Panel box = new Panel();
<1> box.setLayout(new BoxLayout(box, BoxLayout.Y_AXIS));
<1> setContentPane(box);
<1> box.add(new JLabel("This is a test"));
<1> i try this
<4> Slow, steady, calculated, step by step process of building the interface.
Return to
#mysql
or
Go to some related
logs:
xawtv ati tv wonder elite
ldap quotaStorage
disable cd access
xterm cannot allocate color
shell text editor suse
smbfs missing keyword
s-modifier javascript
#math
#asm
#python
|
|