Dsy Network>  www | forum | my | didattica | howto | wiki | el goog | stats | blog | dona | rappresentanti
Homepage
 Register   Calendar   Members  Faq   Search  Logout 
.dsy:it. : Powered by vBulletin version 2.3.1 .dsy:it. > Community > Forum De Bell Tolls > [MS ACCESS] Query Thread Rating: 1 votes, 5.00 average.
Pages (2): « 1 [2]   Last Thread   Next Thread
Author
Thread    Expand all | Contract all    Post New Thread    Post A Reply
Collapse
fozzy
apprentice monk

User info:
Registered: May 2002
Posts: 1968 (0.23 al dì)
Location: Bollate (MI)
Corso: SA-299
Anno: primo...di studio "serio"
Time Online: 10 Days, 10:57:44 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

io accedevo in PHP ad un DB access.. non mi dire che con Java ("che è meglio") non si riesce.. :D

__________________
I sense much NT in you, NT leads to Blue Screens,
Blue Screens lead to downtime, downtime leads to suffering.

NT is the path to the Dark Side....
19-08-2003 21:28
Click Here to See the Profile for fozzy Click here to Send fozzy a Private Message Visit fozzy's homepage! Find more posts by fozzy Add fozzy to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
0m4r
.grande:maestro.

User info:
Registered: Mar 2002
Posts: 7287 (0.84 al dì)
Location: Düsseldorf (DE)
Corso:
Anno: ESAMI FINITI
Time Online: 49 Days, 0:57:33 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

si si riesce ad accedervi, ma poi non riesco a "navigare" fra il risultato della query...

__________________
http://www.twitter.com/0m4r
20-08-2003 08:39
Click Here to See the Profile for 0m4r Click Here to See the Blog of 0m4r Click here to Send 0m4r a Private Message Find more posts by 0m4r Add 0m4r to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
webwarrior
Very Cool Guy

User info:
Registered: Oct 2002
Posts: 197 (0.02 al dì)
Location: Steppa Brianzola
Corso: Informatica
Anno: Settimo?
Time Online: 1 Day, 1:02:00: [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

Cosa intendi per "i record dal 5° al 10°" ? Sarebbe corretto specificare un criterio d'ordine poiché Access (et al.) tendono a riordinare i recordset non ordinati. Boh...

Cmq prova con SELECT TOP 10 * FROM tabella WHERE clausola ORDER BY criterio

Oppure cose più esotiche tipo
SELECT TOP 5 * FROM
( SELECT TOP 10 FROM tabella WHERE clausola ODER BY criterio ) ORDER BY criterio DESC

-> insomma prendi i primi dieci, inverti l'odine e poi prendi i primi 5, io sto andando a braccio.

__________________
__________________

a p bertolini
20-08-2003 15:38
Click Here to See the Profile for webwarrior Click Here to See the Blog of webwarrior Click here to Send webwarrior a Private Message Visit webwarrior's homepage! Find more posts by webwarrior Add webwarrior to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
webwarrior
Very Cool Guy

User info:
Registered: Oct 2002
Posts: 197 (0.02 al dì)
Location: Steppa Brianzola
Corso: Informatica
Anno: Settimo?
Time Online: 1 Day, 1:02:00: [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

Originally posted by 0m4r
perche questa insert da l'errore riportato nell'immagine? E sopratutto cosa cavolo significa l'errore?
code:

INSERT INTO SistemaSocieta VALUES ((SELECT LAST(ID) FROM SistemaPartenza), 4)




Non devi specificare i nomi delle colonne?

INSERT INTO SistemaSocieta (Campo1, Campo2) VALUES (....)

__________________
__________________

a p bertolini
20-08-2003 15:40
Click Here to See the Profile for webwarrior Click Here to See the Blog of webwarrior Click here to Send webwarrior a Private Message Visit webwarrior's homepage! Find more posts by webwarrior Add webwarrior to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
0m4r
.grande:maestro.

User info:
Registered: Mar 2002
Posts: 7287 (0.84 al dì)
Location: Düsseldorf (DE)
Corso:
Anno: ESAMI FINITI
Time Online: 49 Days, 0:57:33 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

webwarrior mi hai dato una buona idea anche te...

__________________
http://www.twitter.com/0m4r
20-08-2003 15:41
Click Here to See the Profile for 0m4r Click Here to See the Blog of 0m4r Click here to Send 0m4r a Private Message Find more posts by 0m4r Add 0m4r to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
0m4r
.grande:maestro.

User info:
Registered: Mar 2002
Posts: 7287 (0.84 al dì)
Location: Düsseldorf (DE)
Corso:
Anno: ESAMI FINITI
Time Online: 49 Days, 0:57:33 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

Originally posted by webwarrior
Non devi specificare i nomi delle colonne?

INSERT INTO SistemaSocieta (Campo1, Campo2) VALUES (....)


solo se non li inserisco tutti...o sbaglio?
e poi il messaggio di errore non è che mi sembri poi cosi intelligente!

__________________
http://www.twitter.com/0m4r
20-08-2003 20:12
Click Here to See the Profile for 0m4r Click Here to See the Blog of 0m4r Click here to Send 0m4r a Private Message Find more posts by 0m4r Add 0m4r to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
webwarrior
Very Cool Guy

User info:
Registered: Oct 2002
Posts: 197 (0.02 al dì)
Location: Steppa Brianzola
Corso: Informatica
Anno: Settimo?
Time Online: 1 Day, 1:02:00: [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

Originally posted by 0m4r
solo se non li inserisco tutti...o sbaglio?
e poi il messaggio di errore non è che mi sembri poi cosi intelligente!


Bhé, sì, l'errore non è molto chiaro...

La sintassi è quella, altrimenti in che ordine stai dando i valori? Non è intrinseco nel sistema l'ordinamento effettivo delle colonne, quindi glielo devi dire tu.

Amenoché fai un SELECT INTO tabella

__________________
__________________

a p bertolini
20-08-2003 20:38
Click Here to See the Profile for webwarrior Click Here to See the Blog of webwarrior Click here to Send webwarrior a Private Message Visit webwarrior's homepage! Find more posts by webwarrior Add webwarrior to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
All times are GMT. The time now is 08:18.    Post New Thread    Post A Reply
Pages (2): « 1 [2]   Last Thread   Next Thread
Show Printable Version | Email this Page | Subscribe to this Thread | Add to Bookmarks

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts 		HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is ON
 

Powered by: vBulletin v2.3.1 - Copyright ©2000 - 2002, Jelsoft Enterprises Limited
Mantained by dsy crew (email) | Collabora con noi | Segnalaci un bug | Archive | Regolamento | Licenze | Thanks | Syndacate
Pagina generata in 0.089 seconds (68.10% PHP - 31.90% MySQL) con 23 query.