Jump to content


Photo

Problema Com Insert Into


  • Faça o login para participar
12 replies to this topic

#1 Fon

Fon

    Novato no fórum

  • Usuários
  • 4 posts
  • Sexo:Não informado

Posted 26/05/2004, 01:23

olá,

estou tentando adicionar dados ao meu BD com a comando SQL INSERT INTO como normalmente faria porém estou tendo o seguinte erro:

Error Executing Database Query.  
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][Driver ODBC para Microsoft Access] Parâmetros insuficientes. Eram esperados 6.  
  
The error occurred in C:\Inetpub\wwwroot\goodvibes\module\party\mod_rec.cfm: line 11
 
9 : <CFQUERY DATASOURCE="#DSN#" NAME="add">
10 :  INSERT INTO party (data, nome, info, private, uf, user)
11 :  VALUES ("#data#", "#FORM.nome#", "#FORM.info#", "#FORM.private#", "#FORM.uf#", "#SESSION.user#")
12 : </CFQUERY>

--------------------------------------------------------------------------
 
SQL    INSERT INTO party (data, nome, info, private, uf, user) VALUES ("01/01/04", "dsadsa", "dsadasdsa", "n", "SC", "fon")  
DATASOURCE   goodvibes 
VENDORERRORCODE   -3010 
SQLSTATE   07002 

espero que possam me ajudar!
agradeço pela compreensão...
[]'s

Edição feita por: Fon, 26/05/2004, 01:29.


#2 ChEsTeR

ChEsTeR

    Turista

  • Usuários
  • 55 posts
  • Sexo:Masculino

Posted 26/05/2004, 01:46

Olá Fon, tente dessa maneira e diga se funciona...

<CFQUERY DATASOURCE="#DSN#" NAME="add">
INSERT INTO party (data, nome, info, private, uf, user)
VALUES (#data#,'#FORM.nome#','#FORM.info#','#FORM.private#','#FORM.uf#','#SESSION.user#')
</CFQUERY>


Aguardo respostas ;)

Edição feita por: ChEsTeR, 26/05/2004, 01:46.

LeandroAbdalla.com.br
Saudades Guilherme Blanco...

#3 Fon

Fon

    Novato no fórum

  • Usuários
  • 4 posts
  • Sexo:Não informado

Posted 26/05/2004, 12:28

olá,

obrigado pela ajuda chester... funcionou com aspas simples na no #data# tbm... senão os dados desse campo eram gravados de outra maneira no BD...

veja como ficou:
<CFQUERY DATASOURCE="#DSN#" NAME="add">
 INSERT INTO party (data, nome, info, private, uf, user)
 VALUES ('#data#','#FORM.nome#','#FORM.info#','#FORM.private#','#FORM.uf#','#SESSION.user#')
</CFQUERY>

muito obrigado! :D
[]'s

#4 HaroNism

HaroNism

    Super Veterano

  • Usuários
  • 13822 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 26/09/2017, 05:46

Priligy San Pablo Prix Viagra Sans Ordonnance Cialis Pour Femme En Pharmacie cialis buy online Propecia Covered By Insurance Hair Loss Propecia Salud

#5 RonsisM

RonsisM

    Super Veterano

  • Usuários
  • 15724 posts
  • Sexo:Masculino
  • Localidade:Plovdiv

Posted 28/09/2017, 13:51

Cost Propecia 1 Mg Cheap Kamagra Fast Real Zentel Echinococcosis Online Tablet Overseas cialis price Viagra Vendita Online In Italia
Buy Amoxicillin Children cialis Buy Doxycycline 100mg
Amoxicillin And Chlamydia Kamagra Efectos Secundarios Finax Generic Propecia Hair Loss cialis price Propecia Generico Madrid How To Buy Macrobid Legally Drugs
Acheter Xenical Pas Cher generic cialis Canadianphamarcy24 Dosage Of Amoxicillin For Respiratory Disorder
Where Can I Buy Accutane Yahoo Zentel 400mg Can I Purchase Alcohol And Cephalexin cialis price Brand Cialis Overnight Delivery Buy Accutane Mastercard
Cialis Gibraltar Priligy Dapoxetine Nhs online pharmacy Viagra Soft Tabs
Cephalexin Drug Time Revatio Order cialis buy online Viagra Available At Boots Online

#6 HaroNism

HaroNism

    Super Veterano

  • Usuários
  • 13822 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 03/10/2017, 18:34

Does Amoxicillin Cause Increased Thirst Cialis In Apotheke Cialis In Deutschland levitra pills for sale Acheter Cytotec Pharmacie Vendita Viagra Italia Line Youtube Levitra

#7 HaroNism

HaroNism

    Super Veterano

  • Usuários
  • 13822 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 08/10/2017, 09:18

Amoxicillin With Tasan Viagra 100 Mg 2 Compresse Amoxicillin A Year After Experation Date viagra Mail Order Secure Ordering Amoxicilina Amex Accepted Medicine Buy Tinidazole Online

#8 Miguceamma

Miguceamma

    MiguPenjisse

  • Usuários
  • 11724 posts

Posted 09/10/2017, 15:53

Amoxicilina Internet Where To Buy Cialis Da 10 O Da 20 Mg Viagra Cialis Et Autres levitra pills for sale Side Effects Of Viagra Tablets

#9 HaroNism

HaroNism

    Super Veterano

  • Usuários
  • 13822 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 22/10/2017, 19:34

Cialis Generique Test vardenafil online pharmacy Prezzi Viagra
Paxel Comment Durer Plus Longtemps Cours online pharmacy Kamagra Oral Jelly Quanto Prima
Forum Priligy 2 Propecia Hipertension farmacie a san marino levitra bayer Precios Cialis En Farmacias Generic Free Shipping Clobetasol 0.05% Psoriasis
Get Pyridium Without Perscription Tablet With Free Shipping realcheaplevitra Kamagra Prix En France Amoxicillin Facts

#10 mapedlok

mapedlok

    24 Horas

  • Usuários
  • 453 posts
  • Sexo:Feminino
  • Localidade:West Lafayette

Posted 02/11/2017, 15:59

Discounts! baby products progect12.jpg Products which fall under this return policy can be returned domestically, as long as they are unused and in the original packaging. No questions asked! If a product that falls under this guarantee is found to be counterfeit, you will get a full refund (shipping costs included). buy.png READ MORE GretaWomen Messenger Bags Ladies Tote Small shoulder bag woman brand leather handbag crossbody bag with scarf lock designer bolsas ( 41.65 $)Elephone S7 4G Phablet ( 245.42 $)22 frets tiger flame material maple electric guitar neck wholesale guitar parts musical instruments guitarra accessories ( 115.00 $)XHL-B-WI Full Finger LED Gloves-6.43 $6A Brazilian Deep Curly Virgin Hair Wet And Wavy Brazilian Curly Hair 3Pcs Brazilian Virgin Hair Deep Wave Human Hair Extensions ( 75.39 $)богатыри +и красная шапочка1pcs 18MM 9W Led Eagle Eye DRL Daytime Running Lights Source Backup Reversing Parking Signal Lamps Waterproof ( 1.49 $)3 bundles deals afro kinky curly hair spiral curl weave human hair peruvian virgin hair curly wave aunty funmi bouncy curls fumi ( 46.30 $)Peruvian Virgin Hair With Closure 8A Unprocessed Peruvian Straight Virgin Hair With Closure 3 Bundles Human Hair With Closure ( 98.00 $)2x h4 h13 h7 h11 9005 9006 led car headlight bulbs 50w 8000lm cree chips csp led headlights all in one head lamp front light ( 38.89 $)ангри берс серииTop-handle women bags fashion pu women's leather handbags black messenger bag tassel fur bag ball high quality small bucket bags ( 25.69 $)Deep Wave Brazilian Hair 3 Pcs Brazilian Curly Virgin Hair Brazillian Deep Wave Virgin Hair 8A Unprocessed Human Hair Extensions ( 80.90 $)Multicolor dots woven pure silk mens tie ( 41.19 $) Forzieri 57.jpg
Discounts! best product sites

progect12.jpg
Products which fall under this return policy can be returned domestically, as long as they are unused and in the original packaging. No questions asked!
If a product that falls under this guarantee is found to be counterfeit, you will get a full refund (shipping costs included).

buy.png

READ MORE
Pair of women's classic platinum black pearl earrings ( 4.40 $)
Orange Business Card Holder ( 28.00 $)
оценка книга
multi theft auto
Mini Dot Seven Fold Woven Silk Tie ( 110.00 $)
Repair Kit Box Set garden telecommunications electronics and electric combination 9 sets ( 36.48 $)
Original xiaomi xiaoyi smart car dvr wifi dash camera 165 degree adas 1080p 60fps 2.7inch freeshipping ( 71.99 $)
12 colors lip stick moisturizing matte lipsticks waterproof lip gloss stick cosmetic ( 1.31 $)
Magnetic Levitation Photo Frame-29.30 $
Unprocessed natural human hair ponytail extension 100g bhf full ponytail wig brazilian hair clip ponytail human hair ( 36.75 $)
Cornelian Crown Cufflinks ( 125.00 $)
Blackview BV2000 4G Smartphone-73.21 $
For iphone cable 2 1a fast usb charger cable mini usb smart charging cable for iphone ( 4.99 $)
Quality Men Bags Casual Men Handbags Pu Leather Male Crossbody Bag Men's Travel Messenger Bags Laptop Briefcase for Men HQB1120 ( 32.48 $)
Azdent hot sell battery operated electric toothbrush with 4 brush heads and 4 another brushes head oral hygiene health products ( 47.00 $)


194.jpg
Discounts! top beauty products 2017

progect12.jpg
Products which fall under this return policy can be returned domestically, as long as they are unused and in the original packaging. No questions asked!
If a product that falls under this guarantee is found to be counterfeit, you will get a full refund (shipping costs included).

buy.png

READ MORE
20pcs 10pairs lot women cotton socks summer cute candy color boat socks ankle socks for woman ( 7.90 $)
UMI Super 4G Phablet-259.90 $
96101 European Construction & Real Estate Deck Mounted Antique Brass 3PCS Set Bathtub Shower Basin Mixer Tap Faucet ( 132.02 $)
Mini Ultrasonic Cleaner-39.30 $
Brand new car braid diy genuine leather cowhide car steering wheel cover black 38cm diameter universal size car inner decoration ( 11.60 $)
7A Malaysian virgin hair lace closure straight human hair closure free middle 3 prat straight closure Li&queen hair products ( 40.00 $)
30x 60x industrial stereo boom circuit board microscope with external fluorescence ring light ( 116.38 $)
SZFC E27 40W SMD 5730 LED Corn Light ( $9.39 )
7 am phone
Old Shark 3-in-1 Phone Lens Kit-3.89 $
владимир красное солнышко +и богатыри
1pc 22inch 90g synthetic long straight clip in ribbon ponytail hair extension hairpiece pony tail hair pieces ( 10.06 $)
1000a peak current car jump starter power bank 12v emergency car battery booster multi-function car starter us uk eu au plugs ( 90.89 $)
книга мир
counter 1.6 online


102bb.png

#11 HaroNism

HaroNism

    Super Veterano

  • Usuários
  • 13822 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 03/11/2017, 21:33

Propecia Impacto cialis Secure Isotretinoin Best Buy Fedex 250 Mg Of Amoxicillin For Feline
Amalaki viagra Cialis 10 Mg Comprimidos

#12 LarPhozyHah

LarPhozyHah

    Super Veterano

  • Usuários
  • 14515 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 18/11/2017, 20:03

Kamagra Generique France viagra Best Price On Cialis Coupon
Free Shipping Cod Levaquin Gatigol Over Night Propecia Vom Markt Ed Pills Canada viagra cialis Uk Buy Albenza Oral
Macrobid Low Price Achat Amoxicillin Tablette Pharmacie pharmacy prices for levitra Viagra Vs Propecia
Farmaco Equivalente Priligy cialis Nolvadex For Cheap

#13 HaroNism

HaroNism

    Super Veterano

  • Usuários
  • 13822 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 29/11/2017, 23:15

Effects Of Keflex Use On Dogs Stendra Pills In Us buy viagra Brand Pfizer Viagra Online Viagra Serve La Ricetta How To Find Zoloft
Finasteride Fda Buy Propecia viagra Viagra Prix Suisse
Keflex Allergy Alternative levitra coupon Vendo Cialis Italia




1 user(s) are reading this topic

0 membro(s), 1 visitante(s) e 0 membros anônimo(s)

IPB Skin By Virteq