Jump to content



Photo

Query With Results Fails


  • Please log in to reply
3 replies to this topic

#1 mastercho

mastercho

    Advanced Member

  • Members
  • PipPipPip
  • 30 posts
  • OS:Windows 10
  • Total Memory:More Than 9Gb
  • Framework:v4.5+, unsure
  • License:Professional Edition

Posted 06 July 2018 - 03:04 AM

So i made 2 blocks, "connect to the database" ( which is all fine working for HeidiSQL whenever i try on local) and then click test connection in "connect to database" says the connection is successful

 

Then i make "query with results" block and just write "SELECT * FROM article" and result table to &links but when execute these blocks nothing gets into table &links, what can cause this in case connection/details all is fine?

That's the error message : https://gyazo.com/6d...b8dff4859a4b8f5


Edited by mastercho, 06 July 2018 - 07:13 AM.


#2 UBotBuddy

UBotBuddy

    UBot Studio Training

  • Moderators
  • 3468 posts
  • LocationVirginia
  • OS:Windows 10
  • Total Memory:8Gb
  • Framework:v4.5+, unsure
  • License:Developer Edition

Posted 06 July 2018 - 12:53 PM

From what I can see in your bot.  The "query with results" should be inside your "connect to database" container.

 

Also, make sure that your SQL statements end with a ";"  Ignore the double quotes.

 

I hope that helps.

 

Buddy


UBot Training for FREE!  Yes, that is correct!


#3 mastercho

mastercho

    Advanced Member

  • Members
  • PipPipPip
  • 30 posts
  • OS:Windows 10
  • Total Memory:More Than 9Gb
  • Framework:v4.5+, unsure
  • License:Professional Edition

Posted 10 July 2018 - 02:23 AM

From what I can see in your bot.  The "query with results" should be inside your "connect to database" container.

 

Also, make sure that your SQL statements end with a ";"  Ignore the double quotes.

 

I hope that helps.

 

Buddy

Thank you for pointing my issue ^_^



#4 UBotBuddy

UBotBuddy

    UBot Studio Training

  • Moderators
  • 3468 posts
  • LocationVirginia
  • OS:Windows 10
  • Total Memory:8Gb
  • Framework:v4.5+, unsure
  • License:Developer Edition

Posted 10 July 2018 - 12:00 PM

Not a problem!

 

Buddy


UBot Training for FREE!  Yes, that is correct!





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users