recordset with join involving 3 or more tables

-

the initial value of form fields on page populated following recordset containing join:

select *
from customers_cus, orders_ord
where orders_ord.customerid_ord=customers_cus.customerid_cus , company_cus='" & request.form("companymenu") &"'

whenever database field orders_ord.customerid_ord not null, form fields on page preview fine. however, if orders_ord.customerid_ord null, receive following error message:

adodb.field error '800a0bcd'

either bof or eof true, or current record has been deleted. requested operation requires current record.

how make orders_ord.customerid_ord able null?



More discussions in Develop server-side applications in Dreamweaver


adobe

Comments

Post a Comment

Popular posts from this blog

Thread: PKI Client 5.00 install (for eToken Pro)

-
my company uses aladdin etoken pro authentication on vpn connections. etoken requires pki client application on client machine before os recognize it. app , token work fine on xp, use ubuntu on laptop. aladdin has offered linux version of client, rpm. convinced our internal guys rpms, , i've been trying work couple days. begin with, hp pavilion dv4-1435dx laptop running jaunty 64-bit. - started out converting .rpm .deb using alien: code: sudo alien -d pkiclient-5.00.28-0.x86_64.rpm - worked fine , got nice little .deb - next, ran .deb install client: code: sudo dpkg -i pkiclient_5.00.28-1_amd64.deb - , executed without errors/issues. pdf rpm said there should launcher @ applications > etoken > start etoken pki client, didn't exist. figured might because installed deb instead of rpm. bounced box, still wasn't there. no big deal... - install network manager can configure vpn connection use token: code: sudo aptit...
Read more

ATmega2560-Arduino Pin Mapping

-
hi community, in last days working on project using arduino mega 2560. on planning pin using found bugs in atmega2560-arduino pin mapping . if right there labels (such pwm) in 'mapped pin name' @ wrong row ( mixed pin numbers right one...) in attachment openoffice calc , pdf file corrected table. ( hope ;-) ) i post here tab separated table : code: [select] arduino mega 2560 pin mapping table atmega 2560 pin out arduino mega function nr name function function function mapped pin name function function datasheet 1 pg5 oc0b digital pin 04 pwm 2 pe0 rxd0 pcint8 digital pin 00 rx0 (usart0 receive pin, programming data input or pin change interrupt 8) 3 pe1 txd0 digital pin 01 tx0 (usart0 transmit pin or programming data output) 4 pe2 xck0 ain0 (usart0 external clock  input/output) 5 pe3 oc3a ain1 digital pin 05 pwm 6 pe4 ...
Read more

Crossfader Arduino Tutorial

-
hello i'm super newb please don't bash me much. i'm using led's , i've connected them correctly (finally) , wondering why program here ( http://www.arduino.cc/en/tutorial/colorcrossfader ) doesn't work? say's haven't declared crossfade. read directions on top , said crossfade needs used list order of colors. isn't declared in main part (void loop() )? or need declared before? nevermind void on bottom , needed before voidloop. lol anyways playing rgb led's wondering if has specific way of making them fade in , out different colors? (brightness , color mixing) code: [select] /* * code cross-fading 3 leds, red, green , blue (rgb) * create fades, need 2 things: *  1. describe colors want displayed *  2. list order want them fade in * * describing color: * color array of 3 percentages, 0-100, *  controlling red, green , blue leds * * red red led @ full, blue , green off *   int red = { 100, 0, 0 } * dim white 3 l...
Read more