Assuming fetch is required, the following 18 results were found.
-
'varchar', 'nvarchar', 'text', 'ntext') AND TABLE_SCHEMA='dbo' ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME; OPEN MyCursor FETCH NEXT FROM MyCursor INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN PRINT ' union all ' + @SqlToExecute; FETCH NEXT FROM...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
AS Value, MIN(t1.column_source) AS Source, COUNT(t1.column_value) AS Count FROM ( '; -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN IF @myCounter=0 PRINT @SqlToExecute; ELSE PRINT '...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
TABLE #CountRecordsPerTablePerCol (myValue int, myTable varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @TableToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' +...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
(myValue varchar(max), myColumn varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @ColToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + LTRIM(@ColToProcess) + ' COLLATE ' +...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
@UpdateSqlStatement, N'@UpdateCursor CURSOR OUTPUT', @UpdateCursor OUTPUT SELECT @NumberLeft = SUM(1) FROM #Scramble FETCH NEXT FROM @UpdateCursor INTO @Data WHILE @@FETCH_STATUS = 0 BEGIN -- OPEN RandomID SET @random = CEILING(RAND()*...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
important to declare this as a list of integers l_PackagesToAdd = List:Int(); for each v_PackageRef in l_PackageRefs { // // fetch the package record c_Package = Zoho_Inventory_Package_Slips[ZI_Package_Ref == v_PackageRef]; if(c_Package.count() > 0) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
back, link the feed to the existing account (rather than creating a new one) so previous transactions remain associated. Fetch transactions and verify. Once the connection is restored, click Fetch Transactions to confirm new data flows in. Historical...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
"STRING_TO_REPLACE_PER_ITERATION" with the User ID. Something like: $result=mysql_query($user_list_query); while($row=mysql_fetch_assoc($result)) { $this_user_id=$row['UserID']; $this_user_full=$row['Fullname'];...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
there isn't much time between getting the Session ID, logging in, agreeing, and then running the second function to get the FetchToken. So first, I need a function to get me a Session ID. Once I've used this and signed in once, it will last a few...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
m_SearchCriteria.put("sort_order","A"); m_SearchCriteria.put("sort_by","payment_number"); // // fetch all payments against this customer in order of payment reference (oldest to most recent) r_SearchResults =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= ZDK.Page.getField('Opportunity_Name').getValue(); let v_DealID = r_DealLookup.id; let r_DealDetails = ZDK.Apps.CRM.Deals.fetchById(v_DealID); // get Deal/Opportunity fields we need to refer to var v_OppType = r_DealDetails.Type_of_Opportunity; var...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
*/ // v_CountUnique = 0; v_CountTotal = 0; v_CountDeleted = 0; // // pagination v_PerPage = 500; // // loop through pages to fetch as many as possible for each v_Page in {1,2} { info "Page #" + v_Page; v_PageFactor = v_Page - 1; v_Offset = v_PageFactor...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
for grand total excludes line items which were optional) v_QuoteGrandTotal = 0.00; r_QuoteDetails = ZDK.Apps.CRM.Quotes.fetchById(v_QuoteID); if (r_QuoteDetails.Grand_Total != undefined) { v_QuoteGrandTotal = r_QuoteDetails.Grand_Total; } // determine...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
$_GET['id']); if ($result = mysqli_query($db_connect, $query, MYSQLI_USE_RESULT)) { while($obj = $result->fetch_object()){ $content_count = $obj->ArticleCount; } } } echo $content_count; mysqli_free_result( $db_connect ); Clear as mud? Feel free to use...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
is select student_reference from student_accounts_table where student_ad_account = trim(lower(ad_username)); BEGIN open c1; fetch c1 into student_no; if c1%notfound then student_no := 0; end if; close c1; RETURN student_no; EXCEPTION WHEN OTHERS THEN...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
terms with their frequency count $search_table_results=mysql_query("SELECT DISTINCT column1 FROM table1"); while($row=mysql_fetch_assoc($search_table_results)) { $this_value=trim($row['column1']); $this_value_num=mysql_num_rows(mysql_query("SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
search_rx_escape_terms($terms); $results_rows = array(); $result = mysql_query($filter_sql); if ($result) { while($row=mysql_fetch_assoc($result)) { $row["Score"] = 0; foreach($terms_rx as $term_rx){ $row["Score"] += preg_match_all("/$term_rx/i",...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
"json_encode". How? So here's what I tried and ended up with: If your XML is UTF-8 This is the basic code and will work to fetch some XML and return it in JSON formatting as long as the XML is encoded in UTF-8. // set headers for JSON file //...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB