hello... i am using mysql and webharvest to direct insert data into database
<body> <database connection="jdbc:mysql://localhost/info" jdbcclass="com.mysql.jdbc.Driver" username="XXXX" password="XXXXXXXXXXXX"> insert into AAA (name, email, address) values (<xpath expression="//div[@class='gsc_1usr_aff']"><var name="node"/></xpath>, <xpath expression="//div[@class='gsc_1usr_emlb']"><var name="node"/></xpath>, <xpath expression="//div[@class='gsc_1usr_cby']"><var name="node"/></xpath>) </database> </body>
So issue is in gsc_1usr_aff data with , value (i.e hardvard university,california) so it is throw exception due to , value.
SO how can we ignor that.
Thanks.
Log in to post a comment.
hello...
i am using mysql and webharvest to direct insert data into database
So issue is in gsc_1usr_aff data with , value (i.e hardvard university,california) so it is throw exception due to , value.
SO how can we ignor that.
Thanks.