Forum

eisagogi dekadikou arithmou se sql2000 apo ASP - Από {gef}

thelo na kano eisagogi enos dekadikou stin sql2000 alla i asp krataei stis metablites tous arithmous aftous me , (koma) anti gia . (telia) pou dexete sto insert tis i sql !!Parolo pou stin forma eisagogis o xristis pliktrologei ton dekadiko me . (telia) apothikebete me , (koma)!pos tha mporeso na kano tin asp na blepei tous arithous me . kai oxi me , ??

Απάντηση από:gef

Meta apo poli ligo parapano psaksimo....H apantisei se auto pou rotisa erxete mesa apo tin SQL opou sto insert pou kano prepei stin metabliti altdate pou thelo na peraso ston pinaka temprec, sto pedio altinvdate na doso ta parakato strSQL_Insert= "INSERT INTO dbo.tempRec (AltInvDate) values((case '"& altdate &"' when ' ' then null else convert(datetime, '"& altdate &"', 103) end));" Auto to convert itan ola ta lefta

Απάντηση από:gef

Telika apo to poli programatismo kegonte polla egkefalika kitara!!!Oi erotisi pou exo eisagei stin arxi, akoma tin psaxno!!Tora ti skeftomoun kai apantisa stin erotisei me lathos apantisi!!!ti na po kai ego gia mena :) (otan to antilifthika itan arga) Alla afto to convert itan polla lefta..... :))))) (mporoume kapos na svinoume post pou exoume apantisei lathos sto forum?) DEN EIMAI KALA PREPEI NA PARO ADIA!!